New posts in Alter Table

Memory Optimized Tables - can they really be so difficult to maintain?

Add NOT NULL constraint to large table without table scan

Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?

Quickly change NULL column to NOT NULL

Reset IDENTITY value

SQL set allowed values for a column

Why does ALTER COLUMN to NOT NULL cause massive log file growth?

Alter table on live production databases

I need to run VACUUM FULL with no available disk space

Rotate a table in PostgreSQL