Provided by: postgresql-client-8.3_8.3.1-1_i386
ALTER VIEW - change the definition of a view
ALTER VIEW name RENAME TO newname
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.
name The name (optionally schema-qualified) of an existing view.
The new name of the view.
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
To rename the view foo to bar:
ALTER VIEW foo RENAME TO bar;
ALTER VIEW is a PostgreSQL extension of the SQL standard.
CREATE VIEW [create_view(7)], DROP VIEW [drop_view(l)]