Re: pg schema prefix

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of John DeSoi
> Sent: 18 May 2006 01:03
> To: pgadmin-support(at)postgresql(dot)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.