Das psycopg-Modul

1. Installiert das psycopg-Modul:

   $ 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. Importiert das psycopg-Modul:

   import psycopg2
   

3. Erstellt eine Datenbank:

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

4. Abfragen der Datenbank:

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

5. Zeiger und Verbindung schließen:

   cursor.close()
   conn.close()