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.
The error returned if a view with the name you supplied (view) already exists.
The notice returned if the data type for column in the query definition is of an ambiguous type.
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).
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