CREATE TABLE AS
PostgreSQL User's GuidePrevNextCREATE TABLE ASName CREATE TABLE AS
— Creates a new table
CREATE TABLE table [ ( column [, ...] ) ] AS select_clause
Inputs
table The name of a new table to be created.
column The name of a column. Multiple column names can be specified using
a comma-delimited list of column names.
select_clauseA valid query statement. Refer to SELECT for a description of the
allowed syntax.
Outputs
Refer to CREATE TABLE and SELECT for a summary of possible output
messages.
Description
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.
PrevHomeNextCREATE TABLEUpCREATE TRIGGER
Wyszukiwarka