Documentation → PostgreSQL 6.5

Unsupported versions: 6.5

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL
Prev		Next

CREATE TABLE AS

Name

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_clause: A 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 direct syntax.

Prev	Home	Next
CREATE TABLE	Up	CREATE TRIGGER