diff options
Diffstat (limited to 'doc/src/sgml/ref/create_schema.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_schema.sgml | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index 2602bb1d56f..550acf1a535 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -67,7 +67,8 @@ CREATE SCHEMA IF NOT EXISTS AUTHORIZATION <replaceable class="parameter">user_na <term><replaceable class="parameter">schema_name</replaceable></term> <listitem> <para> - The name of a schema to be created. If this is omitted, the user name + The name of a schema to be created. If this is omitted, the + <replaceable class="parameter">user_name</replaceable> is used as the schema name. The name cannot begin with <literal>pg_</literal>, as such names are reserved for system schemas. @@ -79,9 +80,10 @@ CREATE SCHEMA IF NOT EXISTS AUTHORIZATION <replaceable class="parameter">user_na <term><replaceable class="parameter">user_name</replaceable></term> <listitem> <para> - The name of the user who will own the schema. If omitted, - defaults to the user executing the command. Only superusers - can create schemas owned by users other than themselves. + The role name of the user who will own the new schema. If omitted, + defaults to the user executing the command. To create a schema + owned by another role, you must be a direct or indirect member of + that role, or be a superuser. </para> </listitem> </varlistentry> @@ -197,7 +199,8 @@ CREATE VIEW hollywood.winners AS all objects within it. <productname>PostgreSQL</productname> allows schemas to contain objects owned by users other than the schema owner. This can happen only if the schema owner grants the - <literal>CREATE</> privilege on his schema to someone else. + <literal>CREATE</> privilege on his schema to someone else, or a + superuser chooses to create objects in it. </para> <para> |