Raymond O'Donnell wrote:
> Just wondering - when using a newer pg_dump to dump from an older
> Postgres, does pg_dump automatically generate INSERT statements for
> the data rather than using COPY?
>
> I noticed this today when transferring data to a newer server -
> pg_dump generated INSERTs although I didn't ask for them. Not a
> problem, but I was curious.
Maybe you used the switch -d to specify the database? (like with psql
and some
other client applications).
The switch -d in pg_dump goes for "Generate inserts instead of COPY
commands"
Double-check the syntax/switches for pg_dump (pg_dump --help)
HTH,
Carlos
--