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