-- New to read from Oracle and insert into Postgress --

--0-382561442-1160882253=:13999
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable

Hello Everybody I am new to postgress, I am need to be able to do=0Aa =
select from an Oracle table from postgres and insert the=0Asame information=
into postgres. Sort of "insert into postgres values select from oracl=
e" Is there any way I can do this from postgres? any free plugs ins or=
=0Asomething that allows me to read Oracle tables from postgres? Thank=
s in advance Rafael Orta=0A =0A***************************************=
************** =0ARafael Orta Phone: (609)-330-3193 =0ASr. Oracle DBA Fax: =
(856)-642-7679 =0ATechnical Manager =0AOraprofessionals Email: rorta_us@yah=
oo.com =0A******************************************************=0A =0A
--0-382561442-1160882253=:13999
Content-Type: text/html; charset=ascii
Content-Transfer-Encoding: quoted-printable

ad>

Re: [NOVICE] -- New to read from Oracle and insert into Postgress

Rafael Orta wrote:
> Hello Everybody
>
> I am new to postgress, I am need to be able to do
> a select from an Oracle table from postgres and insert the
> same information into postgres.
>
> Sort of "insert into postgres values select from oracle"
>
> Is there any way I can do this from postgres? any free plugs ins or
> something that allows me to read Oracle tables from postgres?
http://pgfoundry.org/projects/dbi-link/

Just what you need.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend