Re: pg_dump

-----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-----