| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Rafael Orta <rorta_us(at)yahoo(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: -- New to read from Oracle and insert into Postgress |
| Date: | 2006-10-15 03:32:19 |
| Message-ID: | 4531ABC3.20105@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-odbc |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Balvie | 2006-10-15 20:22:41 | UPDATE the field of a table with fields from another table |
| Previous Message | Rafael Orta | 2006-10-15 03:17:33 | -- New to read from Oracle and insert into Postgress -- |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | adf | 2006-10-16 20:13:22 | User authentication process |
| Previous Message | Rafael Orta | 2006-10-15 03:17:33 | -- New to read from Oracle and insert into Postgress -- |