On Tue, Jan 31, 2006 at 12:31:24PM +0100, Peter Eisentraut wrote:
> According to this documentation
> it should work to connect in ECPG like this:
> EXEC SQL CONNECT TO tcp:postgresql://bell.credativ.de:5432/pei AS myconn USER pei IDENTIFIED BY 'geheim';
> (Or perhaps with single quotes, but that doesn't make a difference.)
The example with the single quote is incorrect. I just changed the docs
Without the single quotes though, the statement should work.
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
In response to
pgsql-bugs by date
|Next:||From: Philipp Reisner||Date: 2006-01-31 14:32:56|
|Subject: Re: Endless loop in ExecNestLoop|
|Previous:||From: Peter Eisentraut||Date: 2006-01-31 11:31:24|
|Subject: ECPG connect by URL doesn't work|