From: Bruce Momjian <bruce@momjian.us>
To: Pantelis Theodosiou <ypercube@gmail.com>
Cc: hans@matfyz.cz
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: missing schema_name
Date: Wed, 10 Mar 2021 14:42:21 -0500
Message-ID: <20210310194221.GE16791@momjian.us> (raw)
In-Reply-To: <CAE3TBxx44Y9_fNuOiBrgsoYq=sfFdyN2k1WWjap9SNHcqeP9nA@mail.gmail.com>
References: <161460419524.316.6898287136822574347@wrigleys.postgresql.org>
<CAE3TBxxxuJZPYnVu8fYZh1=N4x8_ok5MMCX6VSpcJ4MftteLrA@mail.gmail.com>
<CAE3TBxx44Y9_fNuOiBrgsoYq=sfFdyN2k1WWjap9SNHcqeP9nA@mail.gmail.com>
On Mon, Mar 1, 2021 at 03:29:02PM +0000, Pantelis Theodosiou wrote:
>
>
> On Mon, Mar 1, 2021 at 2:43 PM Pantelis Theodosiou <ypercube@gmail.com> wrote:
>
>
>
> On Mon, Mar 1, 2021 at 1:42 PM PG Doc comments form <noreply@postgresql.org
> > wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/sql-createschema.html
> Description:
>
> The second and forth syntax for CREATE SCHEMA is missing schema_name.
>
>
> Right. It looks like the 2nd and 4th lines should be removed. The 1st and
> 3rd cover the syntax cases, don't they?
>
>
> Oh, how silly of me. The command
> CREATE SCHEMA AUTHORIZATION role_specification
> creates a schema with same name as role_specification.
>
> It is explained a few lines later:
>
> schema_name
>
> The name of a schema to be created. If this is omitted, the user_name is
> used as the schema name.
So, I assume our docs don't need improvement here.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
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: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, ypercube@gmail.com, hans@matfyz.cz, pgsql-docs@lists.postgresql.org
Subject: Re: missing schema_name
In-Reply-To: <20210310194221.GE16791@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox