Skip site navigation (1) Skip section navigation (2)

Re: SQL query of an ODBC data source?

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-06-13 07:24:38
Subject: Re: [compgeneral] I cant get the description or default value of a field
Previous:From: Ludek FinstrleDate: 2006-06-13 07:12:20
Subject: Re: 8.02.00.02 driver incompatibilities

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group