Re: PostgreSQL to Oracle DBLink - Mailing list pgsql-admin

From Jerry Sievers
Subject Re: PostgreSQL to Oracle DBLink
Date
Msg-id 86r3p0n4i0.fsf@jerry.enova.com
Whole thread Raw
In response to PostgreSQL to Oracle DBLink  ("Saravanan S" <saravanan.s@alshaya.com>)
Responses Re: PostgreSQL to Oracle DBLink  ("Saravanan S" <saravanan.s@alshaya.com>)
List pgsql-admin
"Saravanan S" <saravanan.s@alshaya.com> writes:

> Hi All,
>
> How to achieve DBLink from postgresql to oracle database.


Consider FDW unless you are running a very old Pg version...

http://laurenz.github.io/oracle_fdw/



> Thanks & Regards
>
> Saravanan.S
>
> DBA Officer | Alshaya India,
>
> Block G, Gopalan Global Axis,
>
> Whitefield, Bangalore.
>
> OFFICE: (+91)8030435677
>
> MOBILE: +91-8971345521
>
> www.alshaya.com
>
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Alshaya Confidentiality Notice & Disclaimer
> This email and any attached or transmitted files may contain confidential and/or privileged information and are
intendedsolely for the addressee(s) named. If you have 
> received this information in error, please notify the sender by return email, do not redistribute this email message,
deleteit immediately and keep no copies of it. 
> All opinions expressed in this email are solely those of the author and do not necessarily represent those of
Alshaya.Neither this email nor any attached or 
> transmitted files constitute a binding commitment on behalf of Alshaya. Any purported commitment or purchase order is
subjectto final approval in accordance with our 
> internal procedures and subject to contract in accordance with the relevant laws. References to Alshaya include M.H.
AlshayaCo. W.L.L. and all its affiliated 
> companies.
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


pgsql-admin by date:

Previous
From: "Saravanan S"
Date:
Subject: PostgreSQL to Oracle DBLink
Next
From: John Scalia
Date:
Subject: Trying to change the owner of some tables