conninfo -- コネクション文字列の操作

This module contains a few utility functions to manipulate database connection strings.

psycopg.conninfo.conninfo_to_dict(conninfo: str = '', **kwargs: Any) → Dict[str, Any]

Convert the conninfo string into a dictionary of parameters.

パラメータ:

• conninfo -- A connection string as accepted by PostgreSQL.

• kwargs -- Parameters overriding the ones specified in conninfo.

戻り値:

Dictionary with the parameters parsed from conninfo and kwargs.

Raise ProgrammingError if conninfo is not a a valid connection string.

>>> conninfo_to_dict("postgres://jeff@example.com/db", user="piro")
{'user': 'piro', 'dbname': 'db', 'host': 'example.com'}

psycopg.conninfo.make_conninfo(conninfo: str = '', **kwargs: Any) → str

Merge a string and keyword params into a single conninfo string.

パラメータ:

• conninfo -- A connection string as accepted by PostgreSQL.

• kwargs -- Parameters overriding the ones specified in conninfo.

戻り値:

A connection string valid for PostgreSQL, with the kwargs parameters merged.

Raise ProgrammingError if the input doesn't make a valid conninfo string.

>>> make_conninfo("dbname=db user=jeff", user="piro", port=5432)
'dbname=db user=piro port=5432'