CREATE VIEW

Practical PostgreSQL
Prev		Next

CREATE VIEW

Name

CREATE VIEW -- Creates a view on a table.

CREATE VIEW view AS query

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.

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

Prev	Home	Next
CREATE USER	Up	CURRENT_DATE