Postgres Pro
Downloads
Home   >   mailing lists

Why is pg_dump using INSERTs instead of COPYs? - Mailing list pgsql-hackers

From reina_ga@hotmail.com (Tony Reina)
Subject Why is pg_dump using INSERTs instead of COPYs?
Date
Msg-id 272e4be7.0403310314.303f6900@posting.google.com
Whole thread Raw
Responses Re: Why is pg_dump using INSERTs instead of COPYs?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
I've got a database running PostgreSQL 7.4.2 on Fedora Linux. In the
past, pg_dump would dump database backups using COPY to restore the
data. This time it appears that it has individual INSERTs for each
tuple. Perhaps I'm missing this in the latest documentation, but I
thought COPY was the default unless the --inserts switch is declared.
Can anyone think of why I'd be getting INSERTs?

Thanks.
-Tony

pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: FW: Increasing security in a shared environment ...
Next
From: Peter Eisentraut
Date:
Subject: Re: Why is pg_dump using INSERTs instead of COPYs?