Contents
ALTER SCHEMA
An SQL command to modify the definition of a schema
ALTER SCHEMA is a DDL command to modify the definition of a schema
ALTER SCHEMA was added in PostgreSQL 7.4.
Change history
- PostgreSQL 14
ALTER SCHEMA ... OWNER TO CURRENT_ROLEsyntax added (commit 45b98057)
- PostgreSQL 9.5
ALTER SCHEMA ... OWNER TO { CURRENT_USER | SESSION_USER }syntax added (commit 31eae602)
- PostgreSQL 8.0
ALTER SCHEMA ... OWNER TO ...clause added (commit 0adfa2c3)
- PostgreSQL 7.4
- added (commit b256f242)
Examples
Basic usage example for ALTER SCHEMA:
postgres=# ALTER SCHEMA foo RENAME TO bar; ALTER SCHEMA
References
- PostgreSQL documentation: ALTER SCHEMA