Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- conn = psycopg2.connect(
- "dbname=gpx user=postgres password=postgres host=localhost")
- cur = conn.cursor()
- cur.execute(
- "CREATE TABLE gpx (object_name VARCHAR(50) NOT NULL PRIMARY KEY, object_value xml);")
- with open("bla.gpx", 'r') as gpxfile:
- data = gpxfile.read()
- cur.execute('INSERT INTO gpx (object_name, object_value) VALUES (%(filename)s, %(xmlstring)s)',
- {'filename': filename, 'xmlstring': data})
- conn.commit()
Add Comment
Please, Sign In to add comment