Thread: pg_dump
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?
Bob Pawley
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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
- --
=== 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
iD8DBQFHAsWQATb/zqfZUUQRAo2nAJ93XacJFk4zNyTjGYVa35TC8WmVKQCfVA76
U2PX23XVDdWkK6E73knPAG0=
=pKtH
-----END PGP SIGNATURE-----
Is there a better method of transfering the database and data to between DBs? Bob ----- Original Message ----- From: "Joshua D. Drake" <jd@commandprompt.com> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: <pgsql-general@postgresql.org> Sent: Tuesday, October 02, 2007 3:26 PM Subject: Re: [GENERAL] pg_dump > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > 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 > > > - -- > > === 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 > > iD8DBQFHAsWQATb/zqfZUUQRAo2nAJ93XacJFk4zNyTjGYVa35TC8WmVKQCfVA76 > U2PX23XVDdWkK6E73knPAG0= > =pKtH > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq
-----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@commandprompt.com>
> To: "Bob Pawley" <rjpawley@shaw.ca>
> Cc: <pgsql-general@postgresql.org>
> Sent: Tuesday, October 02, 2007 3:26 PM
> Subject: Re: [GENERAL] 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-----
-----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@commandprompt.com> > To: "Bob Pawley" <rjpawley@shaw.ca> > Cc: <pgsql-general@postgresql.org> > Sent: Tuesday, October 02, 2007 3:26 PM > Subject: Re: [GENERAL] 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-----
On Tuesday 02 October 2007 3:37 pm, Bob Pawley wrote: > Is there a better method of transfering the database and data to between > DBs? > > Bob > > From the Postgres website PgFoundry project http://pgfoundry.org/projects/dbi-link/ Commercial products http://www.dbconvert.com/ More commercial projects (not all pertain to your question) http://www.postgresql.org/download/commercial -- Adrian Klaver aklaver@comcast.net