pip install psycopg2
or
pip install psycopg2-binary
psycopg2.
apilevel
Возвращает версию DB API Level
psycopg2.apilevel
# '2.0'
psycopg2.
threadsafety
psycopg2.
paramstyle
psycopg2.
connect
(dsn=None, connection_factory=None, cursor_factory=None, async=False, **kwargs)Возвращает объект psycopg2.connection()
, подключение к БД
con = psycopg2.connect('dbname=test user=postgres password=password')
con = psycopg2.connect(
dbname='test',
user='postgres',
password='password',
host='host',
port='port',
)
from psycopg2.extras import DictConnection, DictCursor
dict_conn = connect('', connection_factory=DictConnection)
dict_conn = connect('', cursor_factory=DictCursor)