Re: A VIEW mimicing a TABLE

From: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: A VIEW mimicing a TABLE
Date: 2006-12-13 17:01:34
Message-ID: 1166029294.27564.14.camel@zorro.isa-geek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-12-13 17:10:16 Re: error messages without schema name
Previous Message Tom Lane 2006-12-13 17:01:06 Re: Online index builds