Name
CREATE VIEW -- Creates a view on a table.
Synopsis
CREATE VIEW view AS query
Parameters
- view
The name of the view to create.
- query
The SQL query to provide the columns and rows of the view.
Results
- CREATE
The message returned when a view is successfully created.
- ERROR: Relation 'view' already exists
The error returned if a view with the name you supplied (view) already exists.
- NOTICE create: attribute "column" has an unknown type
The notice returned if the data type for column in the query definition is of an ambiguous type.
Description
Use CREATE VIEW to define a new table view within the current database.
Note: Views are read-only as of PostgreSQL 7.1.x (the most current version as of the writing of this book).
Example
The following example creates a view of all publishers whose names begin with H:
booktown=# CREATE VIEW h_publishers AS
booktown-# SELECT * FROM publishers WHERE name LIKE 'H%';
CREATE