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

Alter View foo?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Alter View foo?
Date: 2006-03-17 01:45:56
Message-ID: 20060317014556.26415.qmail@web31812.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
I am trying to add additional columns to an existing view.  The ALTER statement doesn't appear to
operate on views. Is there a way to alter the definition of a view without dropping and recreating
it?

Regards,

Richard

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-03-17 05:40:15
Subject: Re: Alter View foo?
Previous:From: Michael GuerinDate: 2006-03-16 22:00:05
Subject: Re: ESTERROR

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