" (d...@ciberforce.net)

Hi List;

I've installed Postgres on a Linux box. I've also installed unixODBC on the same linux box and I can use isql to connect to a remote database via a data source that I've configured in ~/.odbc.ini

My question is this:

Can I access tables in the remote database via a psql query which references the ODBC data source? Something like "select * from datasource.database.table"

I thought postgres was an "ODBC' aware databse but I cannot find any info on how to do this -- I only find info on dblinks which is not what I want...


Thanks in advance...

Hi list;

We've installed the windows version of the postgres odbc driver. However when we attempt to create a link table in sql server via this driver it cannot connect.

Any thoughts on how to debug or resolve this?

Thanks

Hi List;

How can I connect from Postgres on a Linux platform to Sql server ? Will dblink allow this? Do I need a different ODBC driver?

Hi List;

I've setup an ODBC connection from my Linux/Postgres laptop to a Lunux/postgres server. I can connect via isql to the remote database.

How can I select data from the remote database from within an sql statement in psql on my local machine?

For example I'd like to be able to specify the [email protected: s...@database.table] to connect on the fly from straight SQL.

Is this possible?

Hi List;

I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network. Is there a good way to pull this off?

Thanks.

-joe