From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
---|---|
To: | "Mr(dot) DBA" <dba(at)ciberforce(dot)net> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: SQL query of an ODBC data source? |
Date: | 2006-06-13 07:16:44 |
Message-ID: | 20060613071644.GB26631@soptik.pzkagis.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-06-13 07:24:38 | Re: [compgeneral] I cant get the description or default value of a field |
Previous Message | Ludek Finstrle | 2006-06-13 07:12:20 | Re: 8.02.00.02 driver incompatibilities |