Re: Psycopg2 : error message. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Psycopg2 : error message.
Date
Msg-id 53766169.8000404@aklaver.com
Whole thread Raw
In response to Re: Psycopg2 : error message.  (skeeved <skeeved@skeeved.org>)
List pgsql-general
On 05/16/2014 08:07 AM, skeeved wrote:
> Looks like you have an invalid connection string:
>
> conn=psycopg2.connect("dbname='busard_test' user='laurent' host='localhost' password='cactus’")
>
> Try removing the double quotes, they are obscuring the parameter names and values:
>
> conn=psycopg2.connect(dbname=‘busard_test', user=‘laurent', host=‘localhost', password='cactus’)
>
> You were also missing some punctuation between the parameters.

See below for the two ways of specifying connection parameters:

http://initd.org/psycopg/docs/module.html#psycopg2.connect

The OPs way is correct, the only thing is the single quotes are redundant.

>
> --
> skeeved
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: dinesh kumar
Date:
Subject: Re: Monitoring Streaming Replication in 9.2
Next
From: Adrian Klaver
Date:
Subject: Re: Psycopg2 : error message.