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