Re: Can I read data load files without loading in db?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: barry conner <barryc(dot)ctr(at)gmail(dot)com>
Subject: Re: Can I read data load files without loading in db?
Date: 2006-08-25 13:18:23
Message-ID: 200608251518.24702.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Freitag, 25. August 2006 13:51 schrieb Martijn van Oosterhout:
> It really depends on the format they send you. It's either plain text,
> in which case the COPY commands will tell you which fields. If it's the
> custom format you can use tar to extract it IIRC.

You can also use pg_restore to extract "binary" dump formats to plain text.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Brown 2006-08-25 13:25:34 Content of pg_class.relacl
Previous Message Bartosz Belter 2006-08-25 13:10:17 7.4 - data recovery