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
--
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
