Updated on 2023-10-23 GMT+08:00

ALTER LARGE OBJECT

Function

ALTER LARGE OBJECT changes the owner of a large object.

Precautions

Only a system administrator or the owner of the to-be-modified large object can run ALTER LARGE OBJECT.

Syntax

1
2
ALTER LARGE OBJECT large_object_oid 
    OWNER TO new_owner;

Parameter Description

  • large_object_oid

    Specifies the OID of the large object to be modified.

    Value range: an existing large object name

  • OWNER TO new_owner

    Specifies the new owner of the object.

    Value range: an existing username/role name

Examples

None