ALTER VIEW() SQL Commands 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 avail-
able 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 exam-
ple, 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 TA-
BLE.
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.
SEE ALSO
CREATE VIEW [create_view(l)], DROP VIEW [drop_view(l)]
SQL - Language Statements 2008-09-19 ALTER VIEW()
postgresql 8.3.4 - Generated Thu Oct 2 08:35:06 CDT 2008