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_invokeroption added (commit 7faa5fc8)
- PostgreSQL 9.4
WITH [ CASCADED | LOCAL ] CHECK OPTIONsyntax 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 ] VIEWsyntax added (commit 248c67d7)
References
- PostgreSQL documentation: CREATE VIEW