diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-09-25 13:42:46 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-09-25 13:42:46 +0000 |
| commit | f8b6b5f14fcd480d5c45eb77bd6e29b11098d860 (patch) | |
| tree | c320dfdd690f4a518e1f13e0847a1454964a416c /doc/src/sgml/ref/create_table.sgml | |
| parent | dcff8232c192bd30baa01dda234be8162dd518e0 (diff) | |
| download | postgresql-f8b6b5f14fcd480d5c45eb77bd6e29b11098d860.tar.gz | |
Cleanup markup and minor editing to prepare for first release.
Diffstat (limited to 'doc/src/sgml/ref/create_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index c462c1eadc..0081f66726 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1663,6 +1663,102 @@ affect a column or a table. </refsect1> </refentry> + +<REFENTRY ID="SQL-CREATETABLEAS"> + <REFMETA> + <REFENTRYTITLE> + CREATE TABLE + </REFENTRYTITLE> + <REFMISCINFO>SQL - Language Statements</REFMISCINFO> + </REFMETA> + <REFNAMEDIV> + <REFNAME> + CREATE TABLE + </REFNAME> + <REFPURPOSE> + Creates a new table + </REFPURPOSE> + + <REFSYNOPSISDIV> + <REFSYNOPSISDIVINFO> + <DATE>1998-09-22</DATE> + </REFSYNOPSISDIVINFO> + <SYNOPSIS> +CREATE TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> [ ( <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> [, ...] ) ] AS <REPLACEABLE CLASS="PARAMETER">select_clause</REPLACEABLE> + </SYNOPSIS> + + <REFSECT2 ID="R2-SQL-CREATETABLEAS-1"> + <REFSECT2INFO> + <DATE>1998-09-22</DATE> + </REFSECT2INFO> + <TITLE> + Inputs + </TITLE> + <PARA> + + <VARIABLELIST> + <VARLISTENTRY> + <TERM> + <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> + </TERM> + <LISTITEM> + <PARA> + The name of a new table to be created. + </PARA> + </LISTITEM> + </VARLISTENTRY> + + <VARLISTENTRY> + <TERM> + <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> + </TERM> + <LISTITEM> + <PARA> + The name of a column. Multiple column names can be specified using +a comma-delimited list of column names. + </PARA> + </LISTITEM> + </VARLISTENTRY> + + <VARLISTENTRY> + <TERM> + <REPLACEABLE CLASS="PARAMETER">select_clause</REPLACEABLE> + </TERM> + <LISTITEM> + <PARA> +A valid query statement. Refer to SELECT for a description of the +allowed syntax. + </PARA> + </LISTITEM> + </VARLISTENTRY> + </VARIABLELIST> + + <REFSECT2 ID="R2-SQL-CREATETABLEAS-2"> + <REFSECT2INFO> + <DATE>1998-09-22</DATE> + </REFSECT2INFO> + <TITLE> + Outputs + </TITLE> + <PARA> + Refer to CREATE TABLE and SELECT for a summary of possible output +messages. + + <REFSECT1 ID="R1-SQL-CREATETABLEAS-1"> + <REFSECT1INFO> + <DATE>1998-09-22</DATE> + </REFSECT1INFO> + <TITLE> + Description + </TITLE> + <PARA> +CREATE TABLE AS enables a table to be created from the contents of +an existing table. It has functionality equivalent to SELECT TABLE INTO, +but with perhaps a more obvious syntax. + +</refsect1> +</refentry> + <!-- Keep this comment at the end of the file Local variables: mode: sgml |
