postgres set default value column code example

Example 1: postgresql change default value

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

Example 2: POSTGRES INTEGER SET DEFAULT VALUE

score INTEGER DEFAULT 1
/* The variable name is score, and the default value for it is 1 */