Contents
CREATE VIEW
An SQL 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)
Examples
Basic usage example for CREATE VIEW:
postgres=# CREATE VIEW bar AS SELECT * FROM foo WHERE id % 2 <> 0;
CREATE VIEW
postgres=# \d+ bar
View "public.bar"
Column | Type | Collation | Nullable | Default | Storage | Description
--------+---------+-----------+----------+---------+---------+-------------
id | integer | | | | plain |
View definition:
SELECT foo.id
FROM foo
WHERE (foo.id % 2) <> 0;
postgres=# INSERT INTO foo VALUES (1),(2),(3);
INSERT 0 3
postgres=# SELECT * FROM bar ;
id
----
1
3
(2 rows)
References
- PostgreSQL documentation: CREATE VIEW