From ed19b9149abef62981b214df9937581d2d94d53d Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 22 Nov 2001 03:42:32 +0000 Subject: [PATCH] Add mention that ALTER TABLE RENAME affects indexes and sequences too. --- doc/src/sgml/ref/alter_table.sgml | 15 +++++++-------- 1 file changed, 7 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 73f07467cb..7fabba4fb9 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ @@ -169,11 +169,10 @@ ALTER TABLE table The ALTER COLUMN SET STATISTICS form allows you to set the statistics-gathering target for subsequent operations. - The RENAME 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 RENAME 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 table constraint definition clause adds a new constraint to the table using the same syntax as . @@ -345,8 +344,8 @@ DROP TABLE temp; - The clauses to rename columns and tables are Postgres - extensions from SQL92. + The clauses to rename tables, columns, indexes, and sequences are + Postgres extensions from SQL92. -- 2.11.0