1<!-- 2doc/src/sgml/ref/alter_large_object.sgml 3PostgreSQL documentation 4--> 5 6<refentry id="sql-alterlargeobject"> 7 <indexterm zone="sql-alterlargeobject"> 8 <primary>ALTER LARGE OBJECT</primary> 9 </indexterm> 10 11 <refmeta> 12 <refentrytitle>ALTER LARGE OBJECT</refentrytitle> 13 <manvolnum>7</manvolnum> 14 <refmiscinfo>SQL - Language Statements</refmiscinfo> 15 </refmeta> 16 17 <refnamediv> 18 <refname>ALTER LARGE OBJECT</refname> 19 <refpurpose>change the definition of a large object</refpurpose> 20 </refnamediv> 21 22 <refsynopsisdiv> 23<synopsis> 24ALTER LARGE OBJECT <replaceable class="parameter">large_object_oid</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER } 25</synopsis> 26 </refsynopsisdiv> 27 28 <refsect1> 29 <title>Description</title> 30 31 <para> 32 <command>ALTER LARGE OBJECT</command> changes the definition of a 33 large object. 34 </para> 35 36 <para> 37 You must own the large object to use <command>ALTER LARGE OBJECT</command>. 38 To alter the owner, you must also be a direct or indirect member of the new 39 owning role. (However, a superuser can alter any large object anyway.) 40 Currently, the only functionality is to assign a new owner, so both 41 restrictions always apply. 42 </para> 43 </refsect1> 44 45 <refsect1> 46 <title>Parameters</title> 47 48 <variablelist> 49 <varlistentry> 50 <term><replaceable>large_object_oid</replaceable></term> 51 <listitem> 52 <para> 53 OID of the large object to be altered 54 </para> 55 </listitem> 56 </varlistentry> 57 58 <varlistentry> 59 <term><replaceable>new_owner</replaceable></term> 60 <listitem> 61 <para> 62 The new owner of the large object 63 </para> 64 </listitem> 65 </varlistentry> 66 </variablelist> 67 </refsect1> 68 69 <refsect1> 70 <title>Compatibility</title> 71 72 <para> 73 There is no <command>ALTER LARGE OBJECT</command> statement in the SQL 74 standard. 75 </para> 76 </refsect1> 77 78 <refsect1> 79 <title>See Also</title> 80 81 <simplelist type="inline"> 82 <member><xref linkend="largeobjects"/></member> 83 </simplelist> 84 </refsect1> 85 86</refentry> 87