Re: Forcing pg_dump NOT to use "INSERT..." - Mailing list pgsql-admin

Hi,

Yes that's right

But You can avoid it by adding

'-s, --schema-only' it will copy only structure without data

Regards,

Andrzej Schulz
Galileo-Selidor


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of David F. Skoll
Sent: Tuesday, November 04, 2003 3:42 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Forcing pg_dump NOT to use "INSERT..."

Hi,

On Red Hat 9, when I run the pg_dump command, it uses the
"INSERT ...." dump format.  I thought it only did that if you used the
--inserts option.  How do I force it NOT to use that format?

Regards,

David.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
      joining column's datatypes do not match