Tom Lane wrote: > Rafal Pietrak <rafal@xxxxxxxxxxxxxxxxxx> writes: >> I can see that with a VIEW, I can do prity mutch everything I can do >> with a TABLE, so a VIEW mimics a TABLE quite well.... but one feature: a >> default value for a row on INSERT. > > 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 After blinking my eyes a few times, I tested this and indeed: You can use ALTER TABLE on a view. Amazing... /me makes a note to check the archives why there is no ALTER VIEW command. -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
