Using PostgreSQL from Python

temp.py

import psycopg2
conn = psycopg2.connect("dbname='timesheets' user=postgres")
if True:
    cur = conn.cursor()

    sql = """
        CREATE TABLE IF NOT EXISTS \"public\".\"ts\" (
            id serial primary key,
            dt date,
            project text,
            consultant text,
            days decimal
            )
    """

    cur.execute(sql)
    
    sql =  """ INSERT INTO \"public\".\"ts\" (
                dt, project, consultant, days
                ) VALUES 
                (%s, %s, %s, %s) 
            """
    cur.executemany(sql, data)
    conn.commit()
    conn.close()