PostgreSQL 8.3.1 Documentation
Prev | Fast Backward |  | Fast Forward | Next

# ALTER VIEW

## Name

ALTER VIEW -- change the definition of a view

## Synopsis

    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, DROP VIEW

Prev | Home | Next
ALTER USER | Up | ANALYZE