# phpman > man > ALTER_SCHEMA(7)

ALTER [SCHEMA(7)](https://www.chedong.com/phpMan.php/man/SCHEMA/7/markdown)                    PostgreSQL 14.23 Documentation                    ALTER [SCHEMA(7)](https://www.chedong.com/phpMan.php/man/SCHEMA/7/markdown)



## NAME
       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.

## SEE ALSO
       CREATE SCHEMA (**CREATE**___**[SCHEMA**(7)](https://www.chedong.com/phpMan.php/man/SCHEMA/7/markdown)), DROP SCHEMA (**DROP**___**[SCHEMA**(7)](https://www.chedong.com/phpMan.php/man/SCHEMA/7/markdown))



PostgreSQL 14.23                                2026                                 ALTER [SCHEMA(7)](https://www.chedong.com/phpMan.php/man/SCHEMA/7/markdown)