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/html/sql-alterschema.html | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 doc/src/sgml/html/sql-alterschema.html (limited to 'doc/src/sgml/html/sql-alterschema.html') diff --git a/doc/src/sgml/html/sql-alterschema.html b/doc/src/sgml/html/sql-alterschema.html new file mode 100644 index 0000000..9593f50 --- /dev/null +++ b/doc/src/sgml/html/sql-alterschema.html @@ -0,0 +1,26 @@ + +ALTER SCHEMA
ALTER SCHEMA
Prev UpSQL CommandsHome Next

ALTER SCHEMA

ALTER SCHEMA — change the definition of a schema

Synopsis

+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. +

Prev Up Next
ALTER RULE Home ALTER SEQUENCE
\ No newline at end of file -- cgit v1.2.3