Connect to remote database via psql?

From: "Mr(dot) DBA" <dba(at)ciberforce(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Connect to remote database via psql?
Date: 2006-06-08 15:56:31
Message-ID: E1FoMs3-0008Lv-5H@webmail11.yourhostingaccount.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Hi List;

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?

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?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Mr. DBA 2006-06-08 16:34:17 Connect from Postgres to Sql Server?
Previous Message Glenn B. Lawler 2006-06-08 14:46:56 Re: DescribParam