What you're looking for is dblink it's in the contrib directory of the postgres distribution. Not sure how it works as I haven't used it but it does have some documentation.
Regards,
Ben
-----Original Message-----
From: Paul R. Sand [mailto:paul_sand@mverify.com]
Sent: 27 January 2004 21:56
To: pgsql-odbc@postgresql.org
Subject: [ODBC] ODBC Connection to External Data Source
I am looking for procedures on how to connect postgres to an external data source (ODBC to Oracle). I then will query the external data source to write into postgres relations. I can't find information on how to set up the ODBC connection from postgres to Oracle so I can use SQL in postgres to access data in the Oracle database. I have the Oracle ODBC drivers install and can access them with Excel. I need to also access the database from postgres. Any suggestions on where I can find information on how to make this OBDC connection?
Thanks!
Paul
*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.
It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************
