Answers for "how to add default value create new field in postgresql"

postgresql change default value

ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';

Posted by: Guest on March-22-2020

postgres default value

ALTER TABLE your_tble ADD COLUMN your_col VARCHAR(8) DEFAULT 'sometext';

Posted by: Guest on August-27-2021

Code answers related to "how to add default value create new field in postgresql"