`CONSTRAINT "CHECK(invoice != '';)" NOT NULL` is **not** a CHECK constraint. It's a NOT NULL constraint whose name is "CHECK(invoice != '';)". You want invoice VARCHAR CHECK(invoice != '') -- or, if you want a named constraint invoice VARCHAR CONSTRAINT 'SomeName' CHECK(invoice != '')