Question : postgresql remove not null constraint
Answered by : homeless-hare-5uzmrehys5rx
alter table users alter column email drop not null;
Source : https://popsql.com/learn-sql/postgresql/how-to-remove-a-not-null-constraint-in-postgresql/ | Last Update : Thu, 19 Mar 20
Question : postgresql add not null and not empty constraint
Answered by : homeless-hare-5uzmrehys5rx
ads character varying(60) NOT NULL CHECK (ads <> '')
Source : https://stackoverflow.com/questions/7951120/sql-not-empty-instead-of-not-null | Last Update : Mon, 02 Mar 20