Re: Problems With VIEWS

On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr  wrote:

> 
> Either way.  I like to create sql files with all of the DDL for creating
> the view and rules.
> Overtime, if I need to change my view or reconfigure the rules, I can edit
> my sql file and then
> call it up in psql using "\e "
> 
> I use the "CREATE OR REPLACE VIEW" syntax to achieve this.
> 

Additional note: REPLACE doesn't work if you are going to change the
list/type/name of your view columns. In 8.2 and above you could use 
DROP VIEW IF EXISTS combined with a following CREATE VIEW, instead.

Bernd