Skip site navigation (1) Skip section navigation (2)

FW: Multiple databases question

From: "Jagaraj, Peter" <peter(dot)jagaraj(at)gmacrfc(dot)com>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: FW: Multiple databases question
Date: 2003-02-07 19:29:14
Message-ID: 34F479803A00524D8B4C7FE9A93E92E0500E7A@SMSPAP41M.na.corp.gmacrfc.com (view raw or flat)
Thread:
Lists: pgsql-odbc
 
Here is the situation:
 
I have a bunch of tables in PostgreSQL. Our production db is Oracle running
on Unix. I would like to read records from PostgreSQL and insert them into
Oracle tables. Is there a simple way, say via PSQL or PL/SQL routine, to do
this?
 
Thanks
 
  
  _____  

                      Peter Jagaraj 

             Data Warehouse Analyst 
Enterprise Technology Services 

     Phone:(952) 857-6151   Fax:(952) 238-8711 
                                  GMAC- RFC 
            <mailto:peter(dot)jagaraj(at)gmacrfc(dot)com> peter(dot)jagaraj(at)gmacrfc(dot)com 

 

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2003-02-08 17:16:35
Subject: Re: ConnInfo assumes signed char
Previous:From: Oliver ElphickDate: 2003-02-07 18:13:17
Subject: ConnInfo assumes signed char

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group