Using imbedded SQL, how do I connect tp Postgresql on a remote host?

From: "J" <summer(at)cucumber(dot)os2(dot)ami(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Using imbedded SQL, how do I connect tp Postgresql on a remote host?
Date: 2001-06-03 10:56:18
Message-ID: 20010603.185612.1344247686.11619@possum.os2.ami.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The documents do not explain clearly enough, and here are no examples
showing how to connect (via TCP/IP) to pg on another host.

I need to supply user, password and database/

Here are examples that do not work:
// exec sql connect "tcp:postgresql://192.168.1.1/cucumbers user
cucumbereater/blackjack";
exec sql connect :sharetrader;

Does someone have code that works?

If you wish to email me, remove the cucumber component above;-)

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-03 16:46:52 Re: Databases compared at zend.com
Previous Message Lamar Owen 2001-06-03 00:13:07 Re: 7.1.2 packaging