ALTER VIEW
Name
ALTER VIEW -- change the definition of a view
Synopsis
ALTER VIEW name RENAME TO newname
Description
ALTER VIEW changes the definition of a view.
The only currently available functionality is to rename the view.
To execute this command you must be the owner of the view.
Parameters
- name
The name (optionally schema-qualified) of an existing view.
- newname
The new name of the view.
Notes
Some variants of ALTER TABLE can be used with
views as well; for example, to rename a view it is also
possible to use ALTER TABLE RENAME. To change
the schema or owner of a view, you currently must use ALTER
TABLE.
Examples
To rename the view foo to
bar:
ALTER VIEW foo RENAME TO bar;
Compatibility
ALTER VIEW is a PostgreSQL
extension of the SQL standard.