Re: [GENERAL] Default column value

Rich Shepard <rshepard@appl-ecosys.com> writes:
>    If a column has a default value specified does this mean the column cannot
> contain a NULL value? In other words, is DEFAULT <some_value> NOT NULL
> redundant?

No, because you can explicitly insert a null.  DEFAULT only controls
what happens when you omit the column in an INSERT command.

            regards, tom lane