SEO

#1 (**permalink**) 04-16-2008, 02:09 AM

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 informationinto 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?

Thanks in advance

Rafael Orta

************************************************** ***
Rafael Orta Phone: (609)-330-3193
Sr. Oracle DBA Fax: (856)-642-7679
Technical Manager
Oraprofessionals Email: rorta_us@yahoo.com
************************************************** ****

#2 (**permalink**) 04-16-2008, 02:10 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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