Обсуждение: 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/