Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. import sys
  2. import psycopg2
  3. conn = psycopg2.connect(database="edbpoc6", user="enterprisedb", password="vitechdba2010", host="172.26.45.193", port="5444")
  4. conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT)
  5. print "Opened database successfully"
  6. cursor = conn.cursor()
  7. f = open('/u02/backup/edb/list/Modified_objects/Packages/CLIENT/pkg_hedge_calculation_batch.sql','r')
  8. cursor.execute(f.read())
  9.  
  10. [root@VITECH-DB-EDB02 var]# python mm.py
  11. Opened database successfully
  12. Traceback (most recent call last):
  13. File "mm.py", line 10, in <module>
  14. cursor.execute(f.read())
  15. psycopg2.ProgrammingError: syntax error at or near ""
  16. LINE 1: 
  17. ^
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement