Re: Dumping from older version

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
--