Release History
Requirements

Introduction

Quick onboard

Deployment

Data Modeling

Connecting

Write data

Migration

Query

Operations and Maintenance

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

ALTER SCHEMA

Change a schema definition.

Synopsis

ALTER SCHEMA name RENAME TO newname

ALTER SCHEMA name OWNER TO newowner

Description

ALTER SCHEMA Changes a schema definition.

Users must have this mode to use ALTER SCHEMA. To rename a schema, the user must also have CREATE privileges for the database. To change the owner, the user must also be a direct or indirect member of the newly owned role, and the role must have CREATE privileges on the database. Note: Superusers automatically have all these privileges.

Parameters

name

  • The name of the existing pattern.

newname

  • The new name of the pattern. New names cannot start with pg_, because these names are reserved for system mode.

newowner

  • New owner of this model.

Compatibility

There is no ALTER SCHEMA statement in the SQL standard.

See also

CREATE SCHEMA, DROP SCHEMA