python.py

#connect to postgres
import psycopg2 

try:
    conn = psycopg2.connect("dbname='databasename' user='user_name' host='localhost' password='pass'")
except:
    print ("I am unable to connect to the database")

cur = conn.cursor()
cur.execute("SELECT * FROM table") #query
rows = cur.fetchall() #fetch array list
for row in rows:
   print ("email = ", row[4], "\n")
conn.commit()
conn.close()