Skip site navigation (1) Skip section navigation (2)

Re: pg schema prefix

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 (view raw or flat)
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.

pgadmin-support by date

Next:From: George PavlovDate: 2006-05-19 19:16:47
Subject: Re: autovacuum?
Previous:From: John DeSoiDate: 2006-05-18 00:02:47
Subject: pg schema prefix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group