diff options
Diffstat (limited to 'doc/src/sgml/ref/select_into.sgml')
| -rw-r--r-- | doc/src/sgml/ref/select_into.sgml | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml new file mode 100644 index 0000000000..ca9958ea05 --- /dev/null +++ b/doc/src/sgml/ref/select_into.sgml @@ -0,0 +1,91 @@ +<refentry id="SQL-SELECTINTO"> + <refmeta> + <refentrytitle> +SELECT INTO + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> +SELECT INTO + </refname> + <refpurpose> +Create a new table from an existing table or view + </refpurpose></refnamediv> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-22</date> + </refsynopsisdivinfo> + <synopsis> +SELECT [ ALL | DISTINCT ] <replaceable class="PARAMETER">expression</replaceable> [ AS <replaceable class="PARAMETER">name</replaceable> ] [, ...] + INTO [TEMP] [ TABLE ] <replaceable class="PARAMETER">new_table</replaceable> ] + [ FROM <replaceable class="PARAMETER">table</replaceable> [<replaceable class="PARAMETER">alias</replaceable>] [, ...] ] + [ WHERE <replaceable class="PARAMETER">condition</replaceable> ] + [ GROUP BY <replaceable class="PARAMETER">column</replaceable> [, ...] ] + [ HAVING <replaceable class="PARAMETER">condition</replaceable> [, ...] ] + [ { UNION [ALL] | INTERSECT | EXCEPT } <replaceable class="PARAMETER">select</replaceable>] + [ ORDER BY <replaceable class="PARAMETER">column</replaceable> [ ASC | DESC ] [, ...] ] + [ FOR UPDATE [OF class_name...]] + [ LIMIT count [OFFSET|, count]] + </synopsis> + + <refsect2 id="R2-SQL-SELECTINTO-1"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> + Inputs + </title> + <para> +All input fields are described in detail for SELECT. + </para> + </refsect2> + + <refsect2 id="R2-SQL-SELECTINTO-2"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> + Outputs + </title> + <para> +All output fields are described in detail for SELECT. + </para> + </refsect2> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-SELECTINTO-1"> + <refsect1info> + <date>1998-09-22</date> + </refsect1info> + <title> + Description + </title> + <para> + SELECT INTO creates a new table from the results of a query. Typically, this + query draws data from an existing table, but any SQL query is allowed. + <note> + <para> + CREATE TABLE AS is functionally equivalent to the SELECT INTO command. + </para> + </note> + </para> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag: +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> |
