set default value in postgresql while creating table code example
Example 1: POSTGRES INTEGER SET DEFAULT VALUE
score INTEGER DEFAULT 1
/* The variable name is score, and the default value for it is 1 */
Example 2: postgres set default value
ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';