|The PostgreSQL 9.0 Reference Manual - Volume 1B - SQL Command Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 488 pages
RRP £14.95 ($19.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
1.30 ALTER VIEW
ALTER VIEW -- change the definition of a view
ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT ALTER VIEW name OWNER TO new_owner ALTER VIEW name RENAME TO new_name ALTER VIEW name SET SCHEMA new_schema
ALTER VIEW changes various auxiliary properties
of a view. (If you want to modify the view's defining query,
CREATE OR REPLACE VIEW.)
You must own the view to use
To change a view's schema, you must also have
privilege on the new schema.
To alter the owner, you must also be a direct or indirect member of the new
owning role, and that role must have
CREATE privilege on
the view's schema. (These restrictions enforce that altering the owner
doesn't do anything you couldn't do by dropping and recreating the view.
However, a superuser can alter ownership of any view anyway.)
- The name (optionally schema-qualified) of an existing view.
These forms set or remove the default value for a column.
A default value associated with a view column is
INSERTstatements on the view before the view's
ON INSERTrule is applied, if the
INSERTdoes not specify a value for the column.
- The user name of the new owner of the view.
- The new name for the view.
- The new schema for the view.
For historical reasons,
ALTER TABLE can be used with
views too; but the only variants of
that are allowed with views are equivalent to the ones shown above.
To rename the view
ALTER VIEW foo RENAME TO bar;
ALTER VIEW is a PostgreSQL
extension of the SQL standard.
|ISBN 9781906966058||The PostgreSQL 9.0 Reference Manual - Volume 1B - SQL Command Reference||See the print edition|