From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/alter_schema.sgml | 100 +++++++++++++++++++++++++++++++++++++ 1 file changed, 100 insertions(+) create mode 100644 doc/src/sgml/ref/alter_schema.sgml (limited to 'doc/src/sgml/ref/alter_schema.sgml') diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml new file mode 100644 index 0000000..04624c5 --- /dev/null +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -0,0 +1,100 @@ + + + + + ALTER SCHEMA + + + + ALTER SCHEMA + 7 + SQL - Language Statements + + + + ALTER SCHEMA + change the definition of a schema + + + + +ALTER SCHEMA name RENAME TO new_name +ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } + + + + + Description + + + ALTER SCHEMA changes the definition of a schema. + + + + You must own the schema to use ALTER SCHEMA. + To rename a schema you must also have the + CREATE privilege for the database. + To alter the owner, you must also be a direct or + indirect member of the new owning role, and you must have the + CREATE privilege for the database. + (Note that superusers have all these privileges automatically.) + + + + + Parameters + + + + name + + + The name of an existing schema. + + + + + + new_name + + + The new name of the schema. The new name cannot + begin with pg_, as such names + are reserved for system schemas. + + + + + + new_owner + + + The new owner of the schema. + + + + + + + + Compatibility + + + There is no ALTER SCHEMA statement in the SQL + standard. + + + + + See Also + + + + + + + + -- cgit v1.2.3