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

Re: ECPG connect by URL doesn't work

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ECPG connect by URL doesn't work
Date: 2006-01-31 13:33:46
Message-ID: 20060131133346.GA21135@1 (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Jan 31, 2006 at 12:31:24PM +0100, Peter Eisentraut wrote:
> According to this documentation
> 
> http://www.postgresql.org/docs/8.1/static/ecpg-connect.html
> 
> 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
accordingly.

Without the single quotes though, the statement should work.

Michael
-- 
Michael Meskes
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 ReisnerDate: 2006-01-31 14:32:56
Subject: Re: Endless loop in ExecNestLoop
Previous:From: Peter EisentrautDate: 2006-01-31 11:31:24
Subject: ECPG connect by URL doesn't work

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