Rafal Pietrak <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
