Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general