Re: pg_dump

Is there a better method of transfering the database and data to between
DBs?

Bob

----- Original Message -----
From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)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