Search Postgresql Archives

Re: pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux