Date: Wed, 10 Mar 2021 14:42:21 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Pantelis Theodosiou <ypercube@gmail.com>
Cc: hans@matfyz.cz, pgsql-docs@lists.postgresql.org
Subject: Re: missing schema_name
Message-ID: <20210310194221.GE16791@momjian.us>
References: <161460419524.316.6898287136822574347@wrigleys.postgresql.org>
 <CAE3TBxxxuJZPYnVu8fYZh1=N4x8_ok5MMCX6VSpcJ4MftteLrA@mail.gmail.com>
 <CAE3TBxx44Y9_fNuOiBrgsoYq=sfFdyN2k1WWjap9SNHcqeP9nA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAE3TBxx44Y9_fNuOiBrgsoYq=sfFdyN2k1WWjap9SNHcqeP9nA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20210310194221.GE16791%40momjian.us>
Precedence: bulk

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