Re: pg_connect fails, pgsql works

Thanks for your suggestion Ray, but I get the same error even w/o the
values being single-quoted.

-- john

Raymond O'Donnell wrote:
> On 10/03/2008 17:37, John Cartwright wrote:
>
>> $con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
>> sslmode='allow' user='test' password='mypassword' dbname='test'")
>
> I don't think you need to quote the host, uid, etc - try it without
> the single quotes, e.g.
>
> "host=postgres1.ngdc.noaa.gov port=5432 sslmode=allow user=test [....]"
>
> HTH,
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> ---------------------------------------------------------------