<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.39 2002/03/05 05:33:04 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.40 2002/03/06 20:42:38 momjian Exp $

PostgreSQL documentation

-->

substring operations on a column faster, at the penalty of

increased storage space.

The <literal>RENAME</literal> clause causes the name of a table,

column, index, orsequence to change without changing any of the

column, index,sequenceorview to change without changing any of the

data. The data will remain of the same type and size after the

command is executed.

The ADD <replaceable class="PARAMETER">table_constraint_definition</replaceable> clause

adds a new constraint to the table using the same syntax as <xref

linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-TITLE">.

The DROP CONSTRAINT <replaceable class="PARAMETER">constraint</replaceable> clause

drops all constraints on the table (and its children) that match <replaceable class="PARAMETER">constraint</replaceable>.

The OWNER clause changes the owner of the table to the user <replaceable class="PARAMETER">

new user</replaceable>.

The OWNER clause changes the owner of the table, index, sequence or view to the

user <replaceable class="PARAMETER">new user</replaceable>.

</para>

<para>