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




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