Re: Can I read data load files without loading in db? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Can I read data load files without loading in db?
Date
Msg-id 200608251518.24702.peter_e@gmx.net
Whole thread Raw
In response to Re: Can I read data load files without loading in db?  (Martijn van Oosterhout <kleptog@svana.org>)
List 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/

pgsql-general by date:

Previous
From: Joe Audette
Date:
Subject: Re: [ADMIN] CMS - portal server Question
Next
From: "Bartosz Belter"
Date:
Subject: 7.4 - data recovery