Connect to an URI in postgres

Question

When I am using the following command:

import psycopg2
psycopg2.connect("postgresql://postgres:postgres@localhost/postgres")

It is giving the following error:

psycopg2.OperationalError: missing "=" after
"postgresql://postgres:postgres@localhost/postgres" in connection info string

Can anyone tell me why? How do I fix this?

Answer 1

The connection string passed to psycopg2.connect is not parsed by psycopg2: it is passed verbatim to libpq.

Hope this helps!