public inbox for [email protected]
help / color / mirror / Atom feedFrom: PG Doc comments form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: tables (and other objects) are automatically put into a schema named "public"
Date: Thu, 08 Nov 2018 20:32:19 +0000
Message-ID: <[email protected]> (raw)
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
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: tables (and other objects) are automatically put into a schema named "public"
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox