ALTER TABLE column_constraint specifies the properties of a PRIMARY KEY, FOREIGN KEY, UNIQUE, or CHECK constraint that is part of a new column definition added to a table. Is the name of the ...

ALTER TABLE staging_data ALTER COLUMN extra_info SET DEFAULT 'hello'; -- also note that for big tables on busy DBs the above 2-step form is much preferred over below form as it won't re-write the ...