Students Table Structure

Prepared SQL statement:
SELECT relname, relkind FROM pg_class, pg_user 
WHERE usesysid = relowner
 AND relkind = 'r'
 AND relname NOT LIKE 'pg\_%' 
 AND relname NOT LIKE 'sql\_%' 
ORDER BY relname;
Executed the SQL statement.

Select a table


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