Das psycopg-Modul

1. Installiert das psycopg-Modul:

   Linux/macOS

   $ python3 -m pip install psycopg
   Collecting psycopg
     Downloading psycopg-3.0.1-py3-none-any.whl (140 kB)
        |████████████████████████████████| 140 kB 3.4 MB/s
   Installing collected packages: psycopg
   Successfully installed psycopg-3.0.1
   

   Windows

   C:> python -m pip install psycopg
   Collecting psycopg
     Downloading psycopg-3.0.1-py3-none-any.whl (140 kB)
        |████████████████████████████████| 140 kB 3.4 MB/s
   Installing collected packages: psycopg
   Successfully installed psycopg-3.0.1
   

2. Importiert das psycopg-Modul:

   import psycopg2
   

3. Erstellt eine Datenbank:

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

4. Abragen der Datenbank:

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

5. Zeiger und Verbindung schließen:

   cursor.close()
   conn.close()