> 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).
In response to
pgsql-odbc by date
|Next:||From: Ludek Finstrle||Date: 2006-06-13 07:24:38|
|Subject: Re: [compgeneral] I cant get the description or default value of a field|
|Previous:||From: Ludek Finstrle||Date: 2006-06-13 07:12:20|
|Subject: Re: 8.02.00.02 driver incompatibilities|