> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] 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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to