
Development Versions: devel
This documentation is for an unsupported version of PostgreSQL.



CREATE TABLE AS  --  Creates a new table from the results of a SELECT


CREATE [ TEMPORARY | TEMP ] TABLE table [ (column [, ...] ) ]
     AS select_clause



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 temporary table exists. Any indexes created on a temporary table are automatically temporary as well.




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.


A valid query statement. Refer to SELECT for a description of the allowed syntax.




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.
