Advertisement
Guest User

Untitled

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