pg schema prefix

From: John DeSoi <desoi(at)pgedit(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pg schema prefix
Date: 2006-05-18 00:02:47
Message-ID: 3CC1FA88-F75B-43D5-A529-A96DA74E04B7@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

It seems that pgAdmin treats any schema that starts with "pg" as a
system schema and hides it by default. The docs mention avoiding the
prefix "pg_":

"Schema names beginning with pg_ are reserved for system purposes and
may not be created by users."

http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html

Any reason all "pg" prefixed schemas are hidden rather than using "pg_"?

OS X 10.4, pgAdmin3 1.4.2

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-05-18 07:56:05 Re: pg schema prefix
Previous Message Jim C. Nasby 2006-05-17 21:18:59 Re: autovacuum?