New posts in Alter Column

Change a column to not allow nulls

ALTER TABLE on dependent column

How to alter a column's data type in a PostgreSQL table?

Change a Nullable column to NOT NULL with Default Value

Alter column, add default constraint

Altering a column: null to not null