Changes 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.
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
Rename the view
ALTER VIEW myview RENAME TO newview;
Change the owner of tablespace
ALTER FILESPACE myfs OWNER TO dba;
ALTER VIEW is a Greenplum Database extension of the SQL standard.
Parent topic: SQL Command Reference