How to dump only the the data without schema?

Hey Andre,

Try pg_dump -a --inserts .......

// Dmitriy

On Sat, Sep 25, 2010 at 10:50:25AM +0100, Andre Lopes wrote:

Hi,

I need to generate the dump of a PostgreSQL database only with the
data with INSERT's. It is possible to do this?

Yes, but are you sure you need to do this? It's *very* slow. What
are you using this for?

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

On Sep 25, 2010, at 3:20 PM, Andre Lopes wrote:

Hi,

I need to generate the dump of a PostgreSQL database only with the data with INSERT's. It is possible to do this?

Best Regards,

Use switch -a and --insert. For more information you can use pg_dump --help

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation

Hey Andre,

Try pg_dump -a --inserts .......

// Dmitriy

-----
The voice input and output is very good in this
http://www.tomtop.com/black-ps3-wireless-bluetooth-headset-for-playstation-3.html?aid=z
Wireless PS3 Headset . It is compatible with all PS3 games.Buy from Reliable
http://www.tomtop.com/google-android-7-notebook-3g-tablet-pc-umpc-wifi-mid-pda.html?aid=z
Google Android PC apad Wholesalers.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-dump-only-the-the-data-without-schema-tp2853606p2855184.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.