Re: pg schema prefix

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: pg schema prefix
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40138829D@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответ на pg schema prefix  (John DeSoi <desoi@pgedit.com>)
Список pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] 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.


В списке pgadmin-support по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: pg schema prefix
Следующее
От: "George Pavlov"
Дата:
Сообщение: Re: autovacuum?