Обсуждение: SQL query of an ODBC data source?

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...

> 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...

I don't know about something like this. But if you're enough experienced
in ODBC you could write functions to support it (you have some inspiration
in dblink or dbilink).

Regards,

Luf