psycopg_pool_basic_connection_pool_with_context_manager.py

1import psycopg
2from psycopg_pool import ConnectionPool
3
4# Create a new pool and keep it combined with a context manager
5with ConnectionPool(conninfo="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 is now ready to use
9        conn.execute("INSERT INTO table1 (field) VALUES (%s)", ("foo",))
10        
11        # When the connection context block ends, the connection is
12        # returned to the pool, not closed.
13        
14    # The pool will be closed and all its connections closed 
15    # when the pool context block ends.