Re: How to check is the table system

On Thu, Sep 15, 2005 at 09:12:44PM +0300, ???????????? wrote:

>    In what way can I determine is the table system? ODBC driver does it
> by checking table name's prefix: if it begins with 'pg_' - driver
> desides that the table is system, but that's a bad idea. I can create
> table and call it 'pg_mytable', but it won't become system!

If a table is in the pg_catalog schema, it's a system table.  The pg_
prefix was used as a convention before the introduction of schemas in
7.3 -- users were not supposed to create tables with names beggining
with pg_.  I guess it's still a bad idea to create tables with such
names.

--
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"La gente vulgar solo piensa en pasar el tiempo;
el que tiene talento, en aprovecharlo"