@ypercubeᵀᴹ - I answered this question
dba.stackexchange.com/questions/207321/… , yesterday and you kindly pointed out that my answer wasn't complete (for
DEFAULT
s). However, I have found a case where the rule that you have to put in all columns doesn't hold. It's for PostgreSQL - if you leave the
last field out of an
INSERT
(leaving out the columns) it still works.