Advertisement
Wawrzyn

psycopg2 python

Oct 24th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.65 KB | None | 0 0
  1. import psycopg2
  2.  
  3. try:
  4.     conn = psycopg2.connect("dbname='d86q4npnbodu6d' user='dyncedlninyqrz' host='ec2-46-51-184-229.eu-west-1.compute.amazonaws.com' password='5e92c4cc539d3c48d6c542f3e3a56883106440bffe1c2693c1bff69062070732'")
  5.  
  6.     cur = conn.cursor()
  7.  
  8.     cur.execute("""CREATE TABLE tabela (klucz INT CONSTRAINT p_key PRIMARY KEY, tekst varchar(50),  liczba INT)""")
  9.  
  10.     cur.execute("""INSERT INTO tabela VALUES (1, 'a', -2), (2, 'b', 524), (3, 'c', 0)""")
  11.  
  12.     cur.execute("""SELECT * from tabela""")
  13.  
  14.     rows = cur.fetchall()
  15.  
  16.     for row in rows:
  17.         print(row[0], row[1], row[2])
  18.  
  19. except:
  20.     print("unable to connect to db!")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement