Re: Alter View foo? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Alter View foo?
Date
Msg-id 25424.1142574015@sss.pgh.pa.us
Whole thread Raw
In response to Alter View foo?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-novice
Richard Broersma Jr <rabroersma@yahoo.com> writes:
> Is there a way to alter the definition of a view without dropping and
> recreating it?

You can replace a view with a different computation of the same output
columns, but you can't change the set of output columns.  I'm not sure
why we still enforce that, given that regular tables can be changed more
flexibly ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Alter View foo?
Next
From: chelsea boot
Date:
Subject: Re: Find and Replace All