ALTER VIEW SQL - Language Statements ALTER VIEW change the definition of a view ALTER 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. newname 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 ALTER TABLE. To rename the view foo to bar: ALTER VIEW foo RENAME TO bar; ALTER VIEW is a PostgreSQL extension of the SQL standard.