I would like to know if it is possible to insert a 'null' string in a column which has NOT NULL constraint. I'm using postgresql.
The query would look like the below
INSERT INTO originators(originator, id, regexp) VALUES ('null', 1, -1);
Here the originator column has NOT NULL constraint.