Skip site navigation (1) Skip section navigation (2)

Re: Alter View foo?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Alter View foo?
Date: 2006-03-17 05:40:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Richard Broersma Jr <rabroersma(at)yahoo(dot)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

In response to

pgsql-novice by date

Next:From: chelsea bootDate: 2006-03-17 13:25:11
Subject: Re: Find and Replace All
Previous:From: Richard Broersma JrDate: 2006-03-17 01:45:56
Subject: Alter View foo?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group