>>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Dimitri Fontaine <dim@hi-media.com> writes:
>> My 8.3.1 installation psql \h only gives me:
>> Syntax:
>> ALTER VIEW name RENAME TO newname
>
> You're not the first person to think that ALTER VIEW covers
everything
> that can be done to a view.
>
> I'm starting to think that we should just make ALTER VIEW be an
alias
> for ALTER TABLE (rather than a separate node type as now), and then
list
> in the ALTER VIEW reference page all of the ALTER TABLE variants
that
> will work on views.
From a DBA perspective, it reduces the risk of error if ALTER TABLE
only affects tables, not views, and ALTER VIEW only affects views, not
tables.
-Kevin