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: Connect to remote database via psql? |
Date: | 2006-06-09 08:20:29 |
Message-ID: | 20060609082029.GB8153@soptik.pzkagis.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> I've setup an ODBC connection from my Linux/Postgres laptop to
> a Lunux/postgres server. I can connect via isql to the remote database.
>
> How can I select data from the remote database from within an sql
> statement in psql on my local machine?
Is it ODBC related? I think psql isn't our focus.
BTW psql have to be connected to some backend (PgSQL server). So
I'm not sure if I understand you well.
> For example I'd like to be able to specify the server(at)database(dot)table
> to connect on the fly from straight SQL.
>
> Is this possible?
You could look at contrib/dblink. It could be what are you looking for.
Regards,
Luf
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-06-09 08:23:15 | Re: windows ODBC driver issues |
Previous Message | Ludek Finstrle | 2006-06-09 08:16:37 | Re: Patch for snprintf problem (bug #1000650) |