Thread: pg schema prefix

pg schema prefix

From
John DeSoi
Date:
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




Re: pg schema prefix

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of John DeSoi
> Sent: 18 May 2006 01:03
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] pg schema prefix
>
> 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_"?

Historic reasons I guess - older pgAdmin's used to create and hide
objects with that prefix rather than pg_ because the ODBC driver hides
pg_ by default as well.

Regards, Dave.