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_invoker
option 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 ] DEFAULT
ALTER VIEW ... OWNER TO ...
ALTER VIEW ... SET SCHEMA ...
- following syntax added (commit a0b012a1):
- PostgreSQL 8.3
- added (commit a5589813)
References
- PostgreSQL documentation: ALTER VIEW