import psycopg2
con=psycopg2.connect(dbname= 'dbname', host='host', port= 'port', user= 'user', password= 'pwd')

#once the above code executes and connection is established
# create a cursor
cur = con.cursor()

#now you can execute select statements
cur.execute("SELECT * FROM employee;")

#Next you need to instruct Psycopg how to fetch your data
cur.fetchall()

#Finally, don't forget to close your cursor & connection
cur.close() 
conn.close()