Re: pg_dump - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: pg_dump
Date
Msg-id 4702E4B0.7020709@commandprompt.com
Whole thread Raw
In response to Re: pg_dump  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: Brian Wipf
Date:
Subject: PITR Recovery and out-of-sync indexes
Next
From: Ron Johnson
Date:
Subject: Re: pg_dump