Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

CREATE VIEW

CREATE VIEW gives a query a name that can be used like a table. The view usually stores no result rows; PostgreSQL runs its query when the view is used.

Last updated

Syntax

CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_name [= view_option_value ] [, ... ] ) ] AS query [ WITH [ CASCADED | LOCAL ] CHECK OPTION ]

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • DROP VIEW
  • CREATE TRIGGER
  • CREATE RULE
  • security_invoker
  • WITH CHECK OPTION
  • automatically updatable views

Source: PostgreSQL: Documentation: 18: CREATE VIEW. Checked 2026-11-03.