Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3

Historical version. PostgreSQL 8.3 has reached end of support. See the current manual.

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.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.