<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.32 2001/11/18 20:35:02 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.33 2001/11/22 03:42:32 momjian Exp $

Postgres documentation

-->

The <literal>ALTER COLUMN SET STATISTICS</literal> form allows you to

set the statistics-gathering target for subsequent

<xref linkend="sql-analyze" endterm="sql-analyze-title"> operations.

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

to change without changing any of the data contained in

the affected table. Thus, the table or column will

remain of the same type and size after this command is

executed.

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

column, index, or sequence 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">.

</para>

<para>

The clauses to rename columnsandtables are <productname>Postgres</productname>

extensions from SQL92.

The clauses to renametables,columns, indexes,andsequences are

<productname>Postgres</productname>extensions from SQL92.

</para>

</refsect2>