Re: [SQL] PostgreSQL to Oracle

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
Subject: Re: [SQL] PostgreSQL to Oracle
Date: 2007-03-15 20:20:34
Message-ID: 200703151620.34309.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Friday 09 March 2007 13:32, Jonah H. Harris wrote:
> To copy the data and table definitions, I'd use a database link (on
> the Oracle side) with hsodbc connecting to your PostgreSQL system via
> ODBC.
>

Do you find this works well? I've used it from some older Oracle instances
connecting back into PostgreSQL and the results I had have been flakey at
best.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-03-15 20:26:13 Re: Native type for storing fractions (e.g 1/3)?
Previous Message Florian G. Pflug 2007-03-15 20:15:10 Re: Problem to install pgAdmin

Browse pgsql-sql by date

  From Date Subject
Next Message Jonah H. Harris 2007-03-15 20:47:46 Re: [SQL] PostgreSQL to Oracle
Previous Message T E Schmitz 2007-03-15 18:54:45 Re: join table with itself?