Re: Forcing pg_dump NOT to use "INSERT..."

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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of David F. Skoll
Sent: Tuesday, November 04, 2003 3:42 PM
To: pgsql-admin(at)postgresql(dot)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