Peter Eisentraut wrote:
> 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.
I used "less" to look at one of the files. In this case its named
'db-private.pg-dump.1' and in a subdirectory called 'database' on the
CD. "less" shows much familiar data in the file. I would have assumed
it was in text format.
I don't notice any COPY commands in the file as I'm looking at it via
"less", so I try to locate some via "grep" and it tells me that there
are matches, but that its a binary file so it won't show me the actual
occurrences. !!
I guess that I'll need to try your suggestion of using pg_restore to
extract them to plain text. Apparently I'll need to add software to
this Fedora Core 3 installation since pg_restore isn't defined
currently. Do you recall the switches needed?
Thanks!
-bC