Contents
CREATE VIEW
A DDL command for defining a view
CREATE VIEW
is a DDL command for defining a view.
CREATE VIEW
has always been present in PostgreSQL.
Change history
- PostgreSQL 15
security_invoker
option added (commit 7faa5fc8)
- PostgreSQL 9.4
WITH [ CASCADED | LOCAL ] CHECK OPTION
syntax added (commit 4cbe3ac3)
- PostgreSQL 9.3
CREATE [ RECURSIVE ] VIEW ...
syntax added (commit 58390526)
- PostgreSQL 9.2
CREATE VIEW ... WITH ( view_option_name [= view_option_value] )
syntax added (commit 0e4611c0)
- PostgreSQL 8.1
CREATE [ TEMP | TEMPORARY ] VIEW ...
syntax added (commit 73f63050)
- PostgreSQL 7.3
CREATE [ OR REPLACE ] VIEW
syntax added (commit 248c67d7)
References
- PostgreSQL documentation: CREATE VIEW