# On Windows
py -3 -m venv venv
source venv/Scripts/activate
# On Linux
$ python3 -m venv venv;
$ source venv/bin/activate

pip install psycopg2

import psycopg2

password postgres

password <user_name>

con = psycopg2.connect('dbname='testdb' user='postgres' host='localhost' password='my_password')

cur = con.cursor()

cur.execute("CREATE TABLE test(id serial PRIMARY KEY, name varchar, email varchar)")

cur.execute("SELECT * FROM test")
items = cur.fetchall()

con.commit()

cur.close()
con.close()