How can I connect to postgres data base by input parameters?

Question

I'm trying to connect to a postgres database by using psycopg2. I ask for the user and user password via input. But I think, this way doesnt let me connect to the database. Is there another way to place the values?

I try to connect like this:

connection = psycopg2.connect("host=localhost dbname=dbname user=%s password=%s", (username, password))

This is the error I get:

    connection = _connect(dsn, connection_factory=connection_factory, **kwasync)
TypeError: 'tuple' object is not callable

Do you want to use %-replacement? In that case you are just missing a % sign where you placed a comma between your template-string and the tuple. — SebDieBln
– SebDieBln, Commented May 9, 2022 at 15:44

Adrian Klaver · Accepted Answer · 2022-05-09 14:58:49Z

1

There are a couple of ways to build the connection string from inputs, first:

# From input
user_name = 'some_name'
pwd = 'some_pwd'

connection = psycopg2.connect(host=localhost, dbname=dbname, user=user_name, password=pwd)

Second from here Make dsn:

from psycopg2.extensions import make_dsn
dsn = make_dsn('host=localhost dbname=dbname', user=user_name, password=pwd)
connection = psycopg2.connect(dsn)

UPDATE, forgot the most obvious way:

dsn = 'host=localhost dbname=dbname user=' + user_name + ' password='  + pwd
connection = psycopg2.connect(dsn)

edited May 9, 2022 at 14:58

answered May 9, 2022 at 14:51

Adrian Klaver

20.4k3 gold badges24 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

How can I connect to postgres data base by input parameters?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related