Contents
REASSIGN OWNED
An SQL command for changing ownership of objects owned by a role
REASSIGN OWNED is a utility command for changing ownership of database objects owned by a particular role.
REASSIGN OWNED was added in PostgreSQL 8.2.
Change history
- PostgreSQL 14
CURRENT_ROLEaccepted as role specification (commit 45b98057)
- PostgreSQL 9.5
REASSIGN OWNED BY { CURRENT_USER | SESSION_USER } TO { CURRENT_USER | SESSION_USER }syntax added (commit 31eae602)
- PostgreSQL 8.2
- added (commit cec3b0a9)
References
- PostgreSQL documentation: REASSIGN OWNED