SQL query of an ODBC data source?

Hi List;

I've installed Postgres on a Linux box. I've also installed unixODBC on t=
he 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 referen=
ces the ODBC data source? Something like "select * from datasource.databa=
se.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 wan=
t...


Thanks in advance...




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: SQL query of an ODBC data source?

> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings