PostgreSQL Database Structure
Students Database
Connected to database: students
Prepared SQL statement:
SELECT usename, relname, relkind 
FROM pg_class, pg_user 
WHERE pg_user.usesysid = pg_class.relowner
 AND (pg_class.relkind IN ('r','i'))
 AND NOT (pg_class.relname LIKE 'pg\_%' OR pg_class.relname LIKE 'sql_%') 
ORDER BY relname;
Executed the SQL statement.
Number of rows returned: 12
Owner Relation Type
postgres enrolment r
postgres enrolment_pkey i
postgres lecturer r
postgres lecturer_pkey i
postgres prerequisite r
postgres prerequisite_pkey i
postgres student r
postgres student_pkey i
postgres studididx i
postgres subcodeidx i
postgres subject r
postgres subject_pkey i

Return to Table of Contents

Written by: Darren Waters & Anthony Robinson in 1999 for the Major Project subject.
Maintained by: Brian Retallick
Last Update: 25th February 2003