The psycopg module

1. Install the psycopg module

   $ 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
   

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()