Rechercher une page de manuel
alter_view
Langue: en
Version: 2009-03-12 (fedora - 06/07/09)
Section: 7 (Divers)
NAME
ALTER VIEW - change the definition of a viewSYNOPSIS
ALTER VIEW name RENAME TO newname
DESCRIPTION
ALTER VIEW changes the definition of a view. The only currently available functionality is to rename the view. To execute this command you must be the owner of the view.
PARAMETERS
- name
- The name (optionally schema-qualified) of an existing view.
- newname
- The new name of the view.
NOTES
Some variants of ALTER TABLE can be used with views as well; for example, to rename a view it is also possible to use ALTER TABLE RENAME. To change the schema or owner of a view, you currently must use ALTER TABLE.
EXAMPLES
To rename the view foo to bar:
ALTER VIEW foo RENAME TO bar;
COMPATIBILITY
ALTER VIEW is a PostgreSQL extension of the SQL standard.
SEE ALSO
CREATE VIEW [create_view(7)], DROP VIEW [drop_view(l)]Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre