SEO

#1 (**permalink**) 04-16-2008, 02:01 AM

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

#2 (**permalink**) 04-16-2008, 02:01 AM

> 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL query of an ODBC data source?