Changes the definition of a schema.
ALTER SCHEMA <name> RENAME TO <newname>
ALTER SCHEMA <name> OWNER TO <newowner>
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.
pg_
, as such names are reserved for system schemas.
There is no ALTER SCHEMA
statement in the SQL standard.
Parent topic: SQL Command Reference