public inbox for [email protected]
help / color / mirror / Atom feedtables (and other objects) are automatically put into a schema named "public"
2+ messages / 2 participants
[nested] [flat]
* tables (and other objects) are automatically put into a schema named "public"
@ 2018-11-08 20:32 PG Doc comments form <[email protected]>
2018-11-12 22:06 ` Re: tables (and other objects) are automatically put into a schema named "public" Peter Eisentraut <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2018-11-08 20:32 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: tables (and other objects) are automatically put into a schema named "public"
2018-11-08 20:32 tables (and other objects) are automatically put into a schema named "public" PG Doc comments form <[email protected]>
@ 2018-11-12 22:06 ` Peter Eisentraut <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2018-11-12 22:06 UTC (permalink / raw)
To: [email protected]; [email protected]
On 08/11/2018 21:32, PG Doc comments form wrote:
> 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.
The statement refers to the previous examples and says "by default". I
don't think the statement is incorrect or inappropriate.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-11-12 22:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-11-08 20:32 tables (and other objects) are automatically put into a schema named "public" PG Doc comments form <[email protected]>
2018-11-12 22:06 ` Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox