Go to TogaWare.com Home Page. GNU/Linux Desktop Survival Guide
by Graham Williams 		Duck Duck Go


CLICK HERE TO VISIT THE UPDATED SURVIVAL GUIDE

PostgreSQL Python Access

contents previous up next index

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()


Support further development by purchasing the PDF version of the book.
Other online resources include the Data Science Desktop Survival Guide.
Books available on Amazon include Data Mining with Rattle and Essentials of Data Science.
Popular open source software includes rattle and wajig.
Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 1995-2020 Togaware Pty Ltd. Creative Commons ShareAlike V4.