Received: from p3E9C145E.dip0.t-ipconnect.de
	(root@p3E9C145E.dip0.t-ipconnect.de [62.156.20.94])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA94454
	for <pgsql-interfaces@postgresql.org>;
	Wed, 5 Jan 2000 13:38:04 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.3/Debian 8.9.3-6) id TAA13165;
	Wed, 5 Jan 2000 19:33:36 +0100
Date: Wed, 5 Jan 2000 19:33:36 +0100
From: Michael Meskes <meskes@postgresql.org>
To: nathan@khmere.com
Cc: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] ECPG and remote databases
Message-ID: <20000105193336.B13149@fam-meskes.de>
Mail-Followup-To: nathan@khmere.com,
	"pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgresql.org>
References: <38737EB4.8D412106@khmere.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <38737EB4.8D412106@khmere.com>;
	from nathan@khmere.com on Wed, Jan 05, 2000 at 09:26:12AM -0800

On Wed, Jan 05, 2000 at 09:26:12AM -0800, nathan@khmere.com wrote:
> 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]

exec sql connect TO <connection target>.

> 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 ?

I'm sorry, the man page you have is way outdated. But right now it's
difficult for me to just find the time to fix bugs.

You may look into the test files in the source tree.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!