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