#!/usr/bin/env python3
# Print code and title of all subjects

import psycopg2

try:
  db = psycopg2.connect("dbname=uni")
  cur = db.cursor()
  q = "select code,name from Subjects order by code";
  cur.execute(q)
  for tup in cur.fetchall():
    print(tup[0],tup[1])
except:
   print("DB error")
finally:
   if db:
     db.close()