Contents
CREATE TABLE AS
A DDL command for defining a new table from the results of a query
CREATE TABLE AS is a DDL command for defining a new table from the results of a query.
CREATE TABLE AS was added in PostgreSQL 6.3.
Change history
- PostgreSQL 12
- PostgreSQL 9.5
IF NOT EXISTSsyntax added (commit e39b6f95)
- PostgreSQL 9.1
- option
UNLOGGEDadded (commit 53dbc27c)
- option
- PostgreSQL 8.4
WITH [ NO ] DATAclause added (commit 8ecd5351)
- PostgreSQL 8.2
- PostgreSQL 8.0
- options
WITH/WITHOUT OIDSadded (commit 98dcf085)
- options
- PostgreSQL 7.4
GLOBALclause added (commit ac5fdea6)
- PostgreSQL 7.2
LOCALclause added (commit bcb5aac8)
- PostgreSQL 6.3
- added (commit 2c833a72)
References
- PostgreSQL documentation: CREATE TABLE AS
Categories
See also
CREATE TABLE, SELECT INTO