'\" t .\" Title: ALTER LARGE OBJECT .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot .\" Date: 2024 .\" Manual: PostgreSQL 16.2 Documentation .\" Source: PostgreSQL 16.2 .\" Language: English .\" .TH "ALTER LARGE OBJECT" "7" "2024" "PostgreSQL 16.2" "PostgreSQL 16.2 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" ALTER_LARGE_OBJECT \- change the definition of a large object .SH "SYNOPSIS" .sp .nf ALTER LARGE OBJECT \fIlarge_object_oid\fR OWNER TO { \fInew_owner\fR | CURRENT_ROLE | CURRENT_USER | SESSION_USER } .fi .SH "DESCRIPTION" .PP \fBALTER LARGE OBJECT\fR changes the definition of a large object\&. .PP You must own the large object to use \fBALTER LARGE OBJECT\fR\&. 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\&. .SH "PARAMETERS" .PP \fIlarge_object_oid\fR .RS 4 OID of the large object to be altered .RE .PP \fInew_owner\fR .RS 4 The new owner of the large object .RE .SH "COMPATIBILITY" .PP There is no \fBALTER LARGE OBJECT\fR statement in the SQL standard\&. .SH "SEE ALSO" Chapter\ \&35