import psycopg2

def main(): 
    conn = None
    try:
       #connect to database
       conn = psycopg2.connect(
              dbname='esadgro2_apps_p5', 
              user='esadgro2_apps', 
              host='127.0.0.1', 
              password='220069300')

       #create database cursor
       cur = conn.cursor()

       #execute statement allowing execute method to sanitize 
       cur.execute("SELECT fname,lname, bday, sex, salary from employee")

       #fetch results
       results = cur.fetchall()

       #print rows row by row
       print("\n****Employees Currently Within the Database*****:\n")
       for row in results:
           print("   ", row)
       print("Query Executed Successfully...exiting")

    except (Exception, psycopg2.DatabaseError) as error:
       print("Error connecting to database: ", error)

    finally:
        if(conn):
            cur.close()
            conn.close()
            print("Connection closed")

if __name__ == "__main__":
    main()