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

From Martijn van Oosterhout
Subject Re: Can I read data load files without loading in db?
Date
Msg-id 20060825115150.GF16535@svana.org
Whole thread Raw
In response to Can I read data load files without loading in db?  (barryc.ctr@gmail.com)
Responses Re: Can I read data load files without loading in db?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
On Fri, Aug 25, 2006 at 07:36:38AM -0400, barry conner wrote:
> Thanks for your reply Martijn.
>   I do not know for certain that its in pg_dump format, not having dealt
> with it specificly before.   I will examine the files more closely to look
> for COPY statements.   If not in that format, what else could it be that
> could be shoved right into a postgresql database?    In any case, would an
> associated file (schema type?) tell me the field name arrangements that the
> data files are loaded with?   or if COPY statements are used, would they
> name the fields being targeted?

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.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Can I read data load files without loading in db?
Next
From: Peter Eisentraut
Date:
Subject: Re: invalid byte sequence ?