Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python
- import psycopg2
- conn = psycopg2.connect(database="test", user="postgres", password="usuario", host="127.0.0.1", port="5432")
- print "Opened database successfully"
- cur = conn.cursor()
- cur.execute("UPDATE PERSONA set nombre = 'ANA' where ID=3")
- conn.commit
- print "Total number of rows updated :", cur.rowcount
- cur.execute("SELECT id, nombre from PERSONA")
- rows = cur.fetchall()
- for row in rows:
- print "ID = ", row[0]
- print "NOMBRE = ", row[1]
- print "OPERACION REALIZADA";
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement