-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 One table or many? Transactionally consistent? Live connection or intermittent? On 10/02/07 17:37, Bob Pawley wrote: > Is there a better method of transfering the database and data to between > DBs? > > 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. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHAukNS9HxQb37XmcRAmedAJ4xvRu85AXf4sjqnOU01mVyN/UVQACeP2TR gHjnN3eU93MY3iOxPX+ec2o= =4/LC -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
