Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- try:
- conn = psycopg2.connect("dbname='d86q4npnbodu6d' user='dyncedlninyqrz' host='ec2-46-51-184-229.eu-west-1.compute.amazonaws.com' password='5e92c4cc539d3c48d6c542f3e3a56883106440bffe1c2693c1bff69062070732'")
- cur = conn.cursor()
- cur.execute("""CREATE TABLE tabela (klucz INT CONSTRAINT p_key PRIMARY KEY, tekst varchar(50), liczba INT)""")
- cur.execute("""INSERT INTO tabela VALUES (1, 'a', -2), (2, 'b', 524), (3, 'c', 0)""")
- cur.execute("""SELECT * from tabela""")
- rows = cur.fetchall()
- for row in rows:
- print(row[0], row[1], row[2])
- except:
- print("unable to connect to db!")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement