Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2, json
- conn = psycopg2.connect("dbname=dbname user=user password=pass")
- cr = conn.cursor()
- filename = "linkedin.json"
- file = open(filename, 'r')
- for line in file:
- string_query = """('%s')""" % (str(line).replace("'", ""))
- query = """
- INSERT INTO linkedin (info)
- VALUES %s;
- """ % (string_query)
- cr.execute(query)
- conn.commit()
Add Comment
Please, Sign In to add comment