Answers for "postgres set default value for existing column"

SQL
4

postgresql change default value

ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';
Posted by: Guest on March-22-2020
1

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 "postgres set default value for existing column"

Code answers related to "SQL"

Browse Popular Code Answers by Language