Rich Shepard <rshepard(at)appl-ecosys(dot)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