Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE SEQUENCE IF NOT EXISTS serial;
- CREATE TABLE my_tbl (
- fname varchar(100),
- lname varchar(100),
- company varchar(200),
- id integer PRIMARY KEY DEFAULT nextval('serial')
- );
- conn = psycopg2.connect(dbname=dbname, host=host, port=port, user=user, password=pwd)
- cur = conn.cursor()
- cur.copy_expert("copy {} from STDIN CSV HEADER QUOTE '"'".format(table_name), file)
- cur.execute("commit;")
Add Comment
Please, Sign In to add comment