CREATE TABLE AS - Creates a new table from the results of
a SELECT
SYNOPSIS
CREATE [ TEMPORARY | TEMP ] TABLE table [ (column [, ...] ) ]
AS select_clause
INPUTS
TEMPORARY or TEMP
If specified, the table is created only within this
session, and is automatically dropped on session
exit. Existing permanent tables with the same name
are not visible (in this session) while the tempo
rary table exists. Any indexes created on a tempo
rary table are automatically temporary as well.
table The name of the new table to be created. This
table must not already exist. However, a temporary
table can be created that has the same name as an
existing permanent table.
column The name of a column. Multiple column names can be
specified using a comma-delimited list of column
names. If column names are not provided, they are
taken from the output column names of the SELECT
query.
select_clause
A valid query statement. Refer to SELECT
[select(l)] for a description of the allowed syn
tax.
OUTPUTS
Refer to CREATE TABLE [create_table(l)] and SELECT
[select(l)] for a summary of possible output messages.
DESCRIPTION
CREATE TABLE AS creates a table and fills it with data
computed by a SELECT command. The table columns have the
names and datatypes associated with the output columns of
the SELECT (except that you can override the SELECT column
names by giving an explicit list of column names).
CREATE TABLE AS bears some resemblance to creating a view,
but it is really quite different: it creates a new table
and evaluates the SELECT just once to fill the new table
initially. The new table will not track subsequent changes
to the source tables of the SELECT. In contrast, a view
re-evaluates the given SELECT whenever queried.
[select_into(l)], but it is preferred since it is less
likely to be confused with other uses of the SELECT ...
INTO syntax.
Man(1) output converted with
man2html