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