Обсуждение: How to dump only the the data without schema?
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,
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,
Hey Andre,
Try pg_dump -a --inserts .......
// Dmitriy
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.