Re: pg schema prefix

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----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.