Advertisement
Guest User

Untitled

a guest
Jul 4th, 2016
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. import psycopg2
  2. import pprint
  3. import sys
  4.  
  5. def main():
  6.  
  7. caden = "host='localhost' dbname='my' user='postgres' password='postgrespass'"
  8. print(caden)
  9.  
  10. obj = psycopg2.connect(caden)
  11. objCursor = obj.cursor()
  12.  
  13. objCursor.execute("INSERT INTO _reference10( _idrref, _version, _marked, _predefinedid, _code, _description) VALUES(%s,%s,%s,%s,%s,%s)", ("2752330023waU23621345343271273226304366",0 ,false ,"00000000000000000000000000000000" , "000000014", "Brazil14"))
  14.  
  15. obj.commit()
  16.  
  17. objCursor.execute("SELECT * FROM _reference10;")
  18. registr1=objCursor.fetchall()
  19.  
  20. print(regist1)
  21. objCursor.close()
  22. obj.close()
  23.  
  24. if __name__ =='__main__':
  25. main()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement