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 thequery
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 publishers whose names begin with H:
booktown=# CREATE VIEW h_publishers AS booktown-# SELECT * FROM publishers WHERE name LIKE 'H%'; CREATE
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.