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
