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

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

pgsql-odbc by date

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

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