Advertisement
Guest User

Untitled

a guest
Sep 8th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. import os
  2. import csv
  3. import psycopg2
  4. import time
  5. from datetime import datetime, timedelta
  6. import ftplib
  7. conn = psycopg2.connect (host="xxxx", database="xxx", user="xxx"
  8. ,password="xxx", port="xxx")
  9.  
  10. update_gpis="UPDATE information_3g SET geom =
  11. ST_SetSRID(ST_MakePoint("Easting","Northing"),2326)"
  12.  
  13. cursor = conn.cursor()
  14.  
  15. cursor.execute(update_gpis)
  16. cursor.close()
  17. conn.commit()
  18. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement