psycopg2

pip install psycopg2
or
pip install psycopg2-binary

• connection
• cursor
• exceptions
• extensions
• extras
• sql

apilevel

psycopg2.apilevel

Возвращает версию DB API Level

psycopg2.apilevel
# '2.0'

threadsafety

psycopg2.threadsafety

paramstyle

psycopg2.paramstyle

connect()

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)