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" ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
