Contents
ALTER VIEW
An SQL command for modifying a view
ALTER VIEW is a DDL command for modifying a view.
ALTER VIEW was added in PostgreSQL 8.3.
Change history
- PostgreSQL 15
security_invokeroption added (commit 7faa5fc8)
- PostgreSQL 13
ALTER VIEW ... RENAME COLUMN ...syntax added (commit 30840c92)
- PostgreSQL 9.4
ALTER VIEW ... OWNER TO { CURRENT_USER | SESSION_USER }syntax added (commit 31eae602)
- PostgreSQL 9.2
- PostgreSQL 8.4
- following syntax added (commit a0b012a1):
ALTER VIEW ... ALTER COLUMN ... [ SET | DROP ] DEFAULTALTER VIEW ... OWNER TO ...ALTER VIEW ... SET SCHEMA ...
- following syntax added (commit a0b012a1):
- PostgreSQL 8.3
- added (commit a5589813)
References
- PostgreSQL documentation: ALTER VIEW