psql default value for column 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';