connect using env. variables

From: Hans Ginzel <hans(at)matfyz(dot)cz>
To: psycopg(at)postgresql(dot)org
Subject: connect using env. variables
Date: 2021-03-09 10:45:30
Message-ID: 20210309104530.GN11758@artax.karlin.mff.cuni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Please, there should be a possibility to call connect() without parameters
for connecting using environment variables (PGSERVICE, PGDATABASE,…)
or defaults ($USER(at)localhost/postgres).

Even pg uri postgres:// is valid,
https://www.postgresql.org/docs/current/libpq-connect.html.

>>> d = psycopg2.connect(**parse_dsn('postgres://'))
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 124, in connect
raise TypeError('missing dsn and no parameters')
TypeError: missing dsn and no parameters
>>> d = psycopg2.connect(**parse_dsn(''))
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 124, in connect
raise TypeError('missing dsn and no parameters')
TypeError: missing dsn and no parameters
>>> db = psycopg2.connect()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 124, in connect
raise TypeError('missing dsn and no parameters')
TypeError: missing dsn and no parameters

Thank you in advance,
Hans

Responses

Browse psycopg by date

  From Date Subject
Next Message Sebastiaan Mannem 2021-03-09 10:47:42 Re: connect using env. variables
Previous Message Daniele Varrazzo 2021-03-04 10:33:45 Re: insert DEFAULT value