diff options
Diffstat (limited to 'doc/src/sgml/ref/create_table_as.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_table_as.sgml | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 05cc38cf332..36348c8ad49 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.35 2006/09/16 00:30:17 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.36 2006/09/18 19:54:01 tgl Exp $ PostgreSQL documentation --> @@ -34,9 +34,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name <para> <command>CREATE TABLE AS</command> creates a table and fills it - with data computed by a <command>SELECT</command> command or an - <command>EXECUTE</command> that runs a prepared - <command>SELECT</command> command. The table columns have the + with data computed by a <command>SELECT</command> command. + The table columns have the names and data types associated with the output columns of the <command>SELECT</command> (except that you can override the column names by giving an explicit list of new column names). @@ -196,12 +195,10 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name <term><replaceable>query</replaceable></term> <listitem> <para> - A query statement (that is, a <command>SELECT</command> command - or an <command>EXECUTE</command> command that runs a prepared - <command>SELECT</command> command). Refer to <xref - linkend="sql-select" endterm="sql-select-title"> or <xref - linkend="sql-execute" endterm="sql-execute-title">, - respectively, for a description of the allowed syntax. + A <xref linkend="sql-select" endterm="sql-select-title"> or + <xref linkend="sql-values" endterm="sql-values-title"> command, + or an <xref linkend="sql-execute" endterm="sql-execute-title"> command + that runs a prepared <command>SELECT</> or <command>VALUES</> query. </para> </listitem> </varlistentry> @@ -326,6 +323,7 @@ CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS <member><xref linkend="sql-execute" endterm="sql-execute-title"></member> <member><xref linkend="sql-select" endterm="sql-select-title"></member> <member><xref linkend="sql-selectinto" endterm="sql-selectinto-title"></member> + <member><xref linkend="sql-values" endterm="sql-values-title"></member> </simplelist> </refsect1> |