PostgreSQL – Change Schema Owner

Run the below command to change the owner of a postgres schema where schemaname is the name of the schema and newownername is the new owner.

ALTER SCHEMA schemaname OWNER to newownername;

See also  PostgreSQL - Empty a Table (Delete, Truncate)