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 regards, tom lane
