Re: Connection string - Mailing list pgsql-general

From Michael Meskes
Subject Re: Connection string
Date
Msg-id 20060811160916.GA4924@1
Whole thread Raw
In response to Re: Connection string  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Connection string
List pgsql-general
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!

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: database file encryption
Next
From: Alvaro Herrera
Date:
Subject: Re: How to use the full text index feature on PostgreSQL