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

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.