SQL query of an ODBC data source? - Mailing list pgsql-odbc

From Mr. DBA
Subject SQL query of an ODBC data source?
Date
Msg-id E1FptX9-0006rY-R3@webmail12.yourhostingaccount.com
Whole thread Raw
Responses Re: SQL query of an ODBC data source?  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc


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
connectto 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
dblinkswhich is not what I want... 


Thanks in advance...




pgsql-odbc by date:

Previous
From: "Andrus"
Date:
Subject: Re: 8.02.00.02 driver incompatibilities
Next
From: Hiroshi Inoue
Date:
Subject: Re: 8.02.00.02 driver incompatibilities