system tables

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=# create table pg_test (x int);
ERROR: Illegal class name 'pg_test'
The 'pg_' name prefix is reserved for system catalogs
test=#

Yuck! :-)

Perhaps a new relkind could be added to pg_class; say "R" for system
tables?

T.

--
Timothy H. Keitt
National Center for Ecological Analysis and Synthesis
735 State Street, Suite 300, Santa Barbara, CA 93101
Phone: 805-892-2519, FAX: 805-892-2510
http://www.nceas.ucsb.edu/~keitt/