From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "John DeSoi" <desoi(at)pgedit(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pg schema prefix |
Date: | 2006-05-18 07:56:05 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40138829D@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | George Pavlov | 2006-05-19 19:16:47 | Re: autovacuum? |
Previous Message | John DeSoi | 2006-05-18 00:02:47 | pg schema prefix |