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

See also#

CREATE VIEW