18.6 PostgreSQL Python Access

20200819

import psycopg2

conn = psycopg2.connect(host='test',
                        database='kayon',
                        user='kayon',
                        password='secret')
        
cur = conn.cursor()

cmd = 'SELECT * FROM iris LIMIT 5'
print(cmd)
cur.execute(cmd)

rows = cur.fetchall()

for row in rows:
    print(row[0], row[1], row[2], row[3], row[4])

cur.close()
conn.close()


Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.