-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bob Pawley wrote: > Is there a better method of transfering the database and data to between > DBs? Use your favorite language to do so. Joshua D. Drake > > Bob > > > ----- Original Message ----- From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> > To: "Bob Pawley" <rjpawley@xxxxxxx> > Cc: <pgsql-general@xxxxxxxxxxxxxx> > Sent: Tuesday, October 02, 2007 3:26 PM > Subject: Re: pg_dump > > > Bob Pawley wrote: >>>> I want to be able to convert a PostgreSQL database to other formats >>>> such as Oracle, Access etc. - with, as well as without, the data. >>>> >>>> Can this task be accomplished by employing pg_dump in SQL? > > If you dump with inserts, data only, then yes but it will be slow as > snot to import. > >>>> >>>> Bob Pawley > > >> - ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? >> http://www.postgresql.org/docs/faq - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHAuSwATb/zqfZUUQRAvbQAKCO6YQ7FqLVaZzqaOUlu8H4KF8vFACcD/4u /3d3mr3Xyd/D1e+s6tppopg= =BVWB -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster