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

31 Mar 2004 03:14:08 -0800
reina_ga@hotmail.com (Tony Reina)
Why is pg_dump using INSERTs instead of COPYs?
Am Mittwoch, 31. Mï¿½rz 2004 13:14 schrieb Tony Reina:
> 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.

This is still the case.

> Can anyone think of why I'd be getting INSERTs?

Shell aliases perhaps.


Wed, 31 Mar 2004 14:35:15 +0200
Peter Eisentraut <peter_e@gmx.net>
Re: Why is pg_dump using INSERTs instead of COPYs?
> > 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.
>
> This is still the case.
>
> > Can anyone think of why I'd be getting INSERTs?
>
> Shell aliases perhaps.

No. I just re-checked my aliases in the shell. Nothing for pg_dump.

I'm sure the answer is no, but are there any postgres-specific preference
files that may be causing the behavior (perhaps something I'm missing in
postgresql.conf)?

For the actual command, I'm just saying 'pg_dump -d dbname > dboutput.sql'
Nothing fancy.

-Tony


Wed, 31 Mar 2004 15:42:46 +0200
"Tony and Bryn Reina" <reina_ga@hotmail.com>
Re: Why is pg_dump using INSERTs instead of COPYs?
"Tony and Bryn Reina" <reina_ga@hotmail.com> writes:
> For the actual command, I'm just saying 'pg_dump -d dbname > dboutput.sql'

"-d" is the --inserts switch.

			regards, tom lane

Wed, 31 Mar 2004 10:23:10 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Why is pg_dump using INSERTs instead of COPYs? 