ct3YfNq6

1import psycopg2
2conn = psycopg2.connect("dbname='timesheets' user=postgres")
3if True:
4    cur = conn.cursor()
5
6    sql = """
7        CREATE TABLE IF NOT EXISTS \"public\".\"ts\" (
8            id serial primary key,
9            dt date,
10            project text,
11            consultant text,
12            days decimal
13            )
14    """
15
16    cur.execute(sql)
17    
18    sql =  """ INSERT INTO \"public\".\"ts\" (
19                dt, project, consultant, days
20                ) VALUES 
21                (%s, %s, %s, %s) 
22            """
23    cur.executemany(sql, data)
24    conn.commit()
25    conn.close()