Contents

Change history
References
Categories
See also

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
- USING option added (commit 8586bf7e)
- WITH OIDS option removed (commit 578b2297)
PostgreSQL 9.5
- IF NOT EXISTS clause added (commit e39b6f95)
PostgreSQL 9.1
- UNLOGGED option added (commit 53dbc27c)
PostgreSQL 8.4
- WITH [ NO ] DATA clause added (commit 8ecd5351)
PostgreSQL 8.2
- WITH option for storage parameters added (commit 277807bd)
- ON COMMIT clause added (commit 85c0eac1)
- TABLESPACE option added (commit 85c0eac1)
PostgreSQL 8.0
- WITH / WITHOUT OIDS options added (commit 98dcf085)
PostgreSQL 7.4
- GLOBAL clause added (commit ac5fdea6)
PostgreSQL 7.2
- LOCAL clause added (commit bcb5aac8)
PostgreSQL 6.3
- added (commit 2c833a72)

References

PostgreSQL documentation: CREATE TABLE AS

Categories

See also

CREATE TABLE, SELECT INTO