Re: alter + preserving dependencies

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.
        regards, tom lane