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
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 |