Received: from ns3.khmere.com (216-59-86-175.usa2.flashcom.net
 [216.59.86.175])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA75143
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 5 Jan 2000 12:27:06 -0500 (EST)
	(envelope-from nathan@khmere.com)
From: nathan@khmere.com
Received: from khmere.com ([63.211.149.51])
	by ns3.khmere.com (8.9.2/8.8.7) with ESMTP id RAA80569
	for <pgsql-interfaces@postgreSQL.org>; Wed, 5 Jan 2000 17:27:03 GMT
Sender: nathan@ns3.khmere.com
Message-ID: <38737EB4.8D412106@khmere.com>
Date: Wed, 05 Jan 2000 09:26:12 -0800
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: ECPG and remote databases
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have a question regarding remote databases.

I am programming in C and using  SQL and ecpg on FreeBSD 3.2 with
postgres 6.5.2 / ecpg 2.6.0.

I  want to connect to a remote database as a  specific user. So the man
page for ecpg says to do the following

EXEC SQL CONNECT   dbname[@server][:port]

       or

 <tcp|unix>:postgresql://server[:port][/dbname][?options]

But either way does not work, can someone please let me know the proper
syntax  fo ecpg or how to do this within embedded SQL ?

thank you

nathan