How to use psycopg2 connection string with variables?

Question

I am trying to connect to a Postgres Database with variables like this:

cs = "dbname=%s user=%s password=%s host=%s port=%s",(dn,du,dp,dh,dbp)
con = None
con = psycopg2.connect(cs)

However I get the error message:

TypeError: argument 1 must be string, not tuple

I need to be able to use variables in the connection string. Anyone know how to accomplish this?

rp372 · Accepted Answer · 2015-08-20 13:20:55Z

17

Your code currently creates a tuple with your string and the tuple you are trying to sub. You need:

cs = "dbname=%s user=%s password=%s host=%s port=%s" % (dn,du,dp,dh,dbp)

answered Aug 20, 2015 at 13:20

rp372

3451 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex Kosh · Accepted Answer · 2021-08-25 20:47:07Z

3

You could pass params directly without building connection string:

con = psycopg2.connect(
    dbname=dn,
    user=du,
    password=dp,
    host=dh,
    port=dbp,
)

Docs for more details on psycopg2.connect

answered Aug 25, 2021 at 20:47

Alex Kosh

2,6442 gold badges25 silver badges20 bronze badges