25 lines
477 B
Python
25 lines
477 B
Python
#!/usr/bin/env python
|
|
import psycopg2
|
|
|
|
pg_conn = psycopg2.connect(
|
|
host="localhost",
|
|
dbname="postgres",
|
|
user="postgres",
|
|
password='scripts',
|
|
)
|
|
pg_cursor = pg_conn.cursor()
|
|
|
|
# select first name, last name from all presidents
|
|
pg_cursor.execute('''
|
|
select firstname, lastname from presidents order by termnum
|
|
''')
|
|
|
|
print("{} rows in result set\n".format(pg_cursor.rowcount))
|
|
|
|
for row in pg_cursor.fetchall():
|
|
print(' '.join(row))
|
|
print()
|
|
|
|
pg_conn.close()
|
|
|