ALTER_SCHEMA(7pg14)

💅 NAME 💅

okay so bestie, this is ALTER_SCHEMA from the PostgreSQL 14.24 Documentation — the page about changing the definition of a schema. iconic behavior, honestly.

✨ 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. that’s the whole vibe.

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.) slay for them.

🎀 PARAMETERS 🎀

• name — the name of an existing schema.
• new_name — the new name of the schema. The new name cannot begin with pg_, because those names are reserved for system schemas. no cap.
• new_owner — the new owner of the schema.

🌈 COMPATIBILITY 🌈

There is no ALTER SCHEMA statement in the SQL standard. not a thing. periodt.

🫶 SEE ALSO 🫶

• CREATE SCHEMA (CREATE_SCHEMA(7))
• DROP SCHEMA (DROP_SCHEMA(7))

later bestie 💖 — xoxo, your ALTER_SCHEMA(7) page from PostgreSQL 14.24, dated 2026.