18.6 PostgreSQL Python Access
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, row, row, row, row) 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.