def generate_excel():  #make table based on pgadmin4
    import psycopg2
    import re
    import pandas as pd
    column_names = []
    conn = psycopg2.connect("dbname='d8kmt03u16v621' user='ub7ar8om9fr3du' host='ec2-34-255-107-246.eu-west-1.compute.amazonaws.com' port='5432' password='p8fd5edd65c34fc3821be8507673ed326c4f116b7d4e7a6515765dab9fdafd028'")
    cur = conn.cursor()
    cur.execute("""select * from 
   (SELECT "prolific_id" ,"tt","is_mobile" ,"offer_accepted"
              
       FROM  public.consent_player
    
    ORDER BY id ASC) tm
""")
    column_names = [desc[0] for desc in cur.description]

    result = cur.fetchall() 
    df=pd.DataFrame(list(result),columns=column_names)
    df.to_excel("result_time_started.xlsx",sheet_name='result')
generate_excel()