· 7 years ago · Oct 14, 2018, 08:46 PM
1CREATE SEQUENCE IF NOT EXISTS serial;
2CREATE TABLE my_tbl (
3 fname varchar(100),
4 lname varchar(100),
5 company varchar(200),
6 id integer PRIMARY KEY DEFAULT nextval('serial')
7);
8
9conn = psycopg2.connect(dbname=dbname, host=host, port=port, user=user, password=pwd)
10cur = conn.cursor()
11cur.copy_expert("copy {} from STDIN CSV HEADER QUOTE '"'".format(table_name), file)
12cur.execute("commit;")