ALTER VIEW name RENAME TO new_name ALTER VIEW name SET AUTHORIZATION ( user | USER user | ROLE role )
Change the definition of an existing view.
ALTER VIEW people RENAME TO users
Change owner of VIEW
people to user
ALTER VIEW people SET AUTHORIZATION alice