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

Examples

Basic usage example for ALTER SCHEMA:

postgres=# ALTER SCHEMA foo RENAME TO bar;
ALTER SCHEMA

Categories

DDL, Schema (namespace), SQL command

See also

CREATE SCHEMA, DROP SCHEMA, pg_namespace