On Wed, 2006-12-13 at 11:08 -0500, Tom Lane wrote:
> 
> You can add a default to a view's column, either the same as the
> underlying table's default, or different if you want.
> 
> ALTER TABLE view ALTER COLUMN col SET DEFAULT expr

G! The obvious solutions are most difficult to spot. 

Thenx!

-- 
-R

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to