On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <rabroersma@xxxxxxxxx> 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 <view_def.sql>" > > 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
