Rafal Pietrak <rafal@zorro.isa-geek.com> 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