|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.15 2000/10/0519:48:17 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.16 2000/12/20 03:19:24 momjian Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -36,6 +36,8 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
36 | 36 | RENAME TO <replaceable class="PARAMETER">newtable</replaceable> |
37 | 37 | ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
38 | 38 | ADD <replaceable class="PARAMETER">table constraint definition</replaceable> |
| 39 | +ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
| 40 | +OWNER TO <replaceable class="PARAMETER">new owner</replaceable> |
39 | 41 | </synopsis> |
40 | 42 |
|
41 | 43 | <refsect2 id="R2-SQL-ALTERTABLE-1"> |
@@ -100,6 +102,16 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
100 | 102 | </para> |
101 | 103 | </listitem> |
102 | 104 | </varlistentry> |
| 105 | + |
| 106 | + <varlistentry> |
| 107 | + <term><replaceable class="PARAMETER">New user </replaceable></term> |
| 108 | + <listitem> |
| 109 | + <para> |
| 110 | +The userid of the new owner of the table. |
| 111 | + </para> |
| 112 | + </listitem> |
| 113 | + </varlistentry> |
| 114 | + |
103 | 115 | </variablelist> |
104 | 116 | </para> |
105 | 117 | </refsect2> |
@@ -158,6 +170,8 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
158 | 170 | The ADD <replaceable class="PARAMETER">table constraint definition</replaceable> clause |
159 | 171 | adds a new constraint to the table using the same syntax as <xref |
160 | 172 | linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-title">. |
| 173 | + The OWNER clause chnages the owner of the table to the user <replaceable class="PARAMETER"> |
| 174 | + new user</replaceable>. |
161 | 175 | </para> |
162 | 176 |
|
163 | 177 | <para> |
|