summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_table.sgml
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>1998-09-25 13:42:46 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>1998-09-25 13:42:46 +0000
commitf8b6b5f14fcd480d5c45eb77bd6e29b11098d860 (patch)
treec320dfdd690f4a518e1f13e0847a1454964a416c /doc/src/sgml/ref/create_table.sgml
parentdcff8232c192bd30baa01dda234be8162dd518e0 (diff)
downloadpostgresql-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.sgml96
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