psycopg_pool_connection_context_manager_quickstart.py

1import psycopg
2from psycopg_pool import ConnectionPool
3
4# The pool can be used as a context manager
5with ConnectionPool("dbname=test user=postgres") as pool:
6    # Use pool.connection() to get a connection from the pool
7    with pool.connection() as conn:
8        # The connection can be used as usual
9        conn.execute(
10            "INSERT INTO mytable (name) VALUES (%s)",
11            ("John",)
12        )
13        # The connection is returned to the pool at the end of the 'with' block