tables (and other objects) are automatically put into a schema named"public"

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема tables (and other objects) are automatically put into a schema named"public"
Дата
Msg-id 154170913923.26250.8601986455411276596@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: tables (and other objects) are automatically put into a schemanamed "public"  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/ddl-schemas.html
Description:

This statement is not true and is contradicted in
https://www.postgresql.org/docs/9.6/sql-createtable.html which states
correctly that:
If a schema name is given (for example, CREATE TABLE myschema.mytable ...)
then the table is created in the specified schema. Otherwise it is created
in the current schema. 
It is also worth mentioning that if current_schema is empty (i.e.
,search_path is empty or contains the names of non-existent schemas)  you
get the error:
ERROR:  no schema has been selected to create in

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: effective_cache_size
Следующее
От: PG Doc comments form
Дата:
Сообщение: The 'replication' keyword