Re: Connection string

On Fri, Aug 11, 2006 at 07:01:55AM -0600, Michael Fuhr wrote:
> The ECPG "Connecting to the Database Server" documentation does
> have an example for Unix sockets with quotes:
>
>  EXEC SQL CONNECT TO 'unix:postgresql://sql.mydomain.com/mydb' AS myconnection USER john;
>
> Should that be changed?  It's wrong on two counts as far as

I think so yes.

> I'm thinking that example should be:
>
>  EXEC SQL CONNECT TO unix:postgresql://localhost/mydb AS myconnection USER john;

Right.

>  In practice, it is probably less error-prone to use a (single-quoted)
>  string literal or a variable reference.
>
> which might be the source of confusion here.

This should be fixed. You're absolutely right.

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@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!