Re: pg_connect fails, pgsql works

[John Cartwright <John(dot)C(dot)Cartwright(at)noaa(dot)gov>]

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
> ---------------------------------------------------------------