The psycopg module

1. Install the psycopg module

   $ uv add psycopg
   Resolved 3 packages in 4ms
   Built psycopg-env @ file:///Users/veit/sandbox/psycopg_env
   Prepared 1 package in 7ms
   Uninstalled 1 package in 0.96ms
   Installed 2 packages in 5ms
    + psycopg==3.3.4
    ~ psycopg-env==0.1.0 (from file:///Users/veit/cusy/trn/python-basics-tutorial)
   

2. Import the psycopg module

   import psycopg2
   

3. Create a database

   conn = psycopg2.connect(dbname="my_db", user="username")
   cursor = conn.cursor()
   

4. Query the database

   cursor.execute("SELECT * FROM my_table")
   row = cursor.fetchone()
   

5. Close cursor and connection

   cursor.close()
   conn.close()