This page in other versions: Unsupported versions: 6.4 / 6.5 / 7.0

SELECT INTO

Name

SELECT INTO — Create a new table from an existing table or view
SELECT [ ALL | DISTINCT ] expression [ AS name ] [, ...]
    INTO [ TABLE ] new_table ]
    [ FROM table [alias] [, ...] ]
    [ WHERE condition ]
    [ GROUP BY column [, ...] ]
    [ HAVING condition [, ...] ]
    [ UNION [ ALL ] select]
    [ ORDER BY column [ ASC | DESC ] [, ...] ]
  

Inputs

All input fields are described in detail for SELECT.

Outputs

All output fields are described in detail for SELECT.

Description

SELECT INTO creates a new table from the results of a query. Typically, this query draws data from an existing table, but any SQL query is allowed.

Note: CREATE TABLE AS is functionally equivalent to the SELECT INTO command.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group