Re: A VIEW mimicing a TABLE - Mailing list pgsql-general

From Rafal Pietrak
Subject Re: A VIEW mimicing a TABLE
Date
Msg-id 1166029294.27564.14.camel@zorro.isa-geek.com
Whole thread Raw
In response to Re: A VIEW mimicing a TABLE  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: Re: MySQL drops support for most distributions
Next
From: "Shoaib Mir"
Date:
Subject: Re: error messages without schema name