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