ALTER_LARGE_OBJECT - change the definition of a large object

There is no ALTERLARGEOBJECT statement in the SQL standard.

ALTERLARGEOBJECT changes the definition of a large object. You must own the large object to use ALTERLARGEOBJECT. To alter the owner, you must also be able to SET ROLE to the new owning role. (However, a superuser can alter any large object anyway.) Currently, the only functionality is to assign a new owner, so both restrictions always apply.

ALTER_LARGE_OBJECT - change the definition of a large object

large_object_oid OID of the large object to be altered new_owner The new owner of the large object

Chapter 33 PostgreSQL 17.5 2025 ALTERLARGEOBJECT(7)

ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }