Why is pg_dump using INSERTs instead of COPYs?

From: reina_ga(at)hotmail(dot)com (Tony Reina)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Why is pg_dump using INSERTs instead of COPYs?
Date: 2004-03-31 11:14:08
Message-ID: 272e4be7.0403310314.303f6900@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2004-03-31 12:32:52 Re: Some Documentation Changes
Previous Message vinayj 2004-03-31 08:06:32 Create Type Problem