---
name: "ALTER_LARGE_OBJECT"
section: "7"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/ALTER_LARGE_OBJECT"
---

# ALTER\_LARGE\_OBJECT(7)

change the definition of a large object

## NAME

ALTER\_LARGE\_OBJECT - change the definition of a large object

## SYNOPSIS

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

## DESCRIPTION

**ALTER LARGE OBJECT** changes the definition of a large object.

You must own the large object to use **ALTER LARGE OBJECT**. 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.

## PARAMETERS

*large\_object\_oid*

OID of the large object to be altered

*new\_owner*

The new owner of the large object

## COMPATIBILITY

There is no **ALTER LARGE OBJECT** statement in the SQL standard.

## SEE ALSO

Chapter 33