new1시간 전· 1 sources
Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID
Why it matters
Disclosure: I build Schemity, a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: On PostgreSQL 11 and later, ADD COLUMN ... NOT NULL DEFAULT 'new' is a catalogue chan...
1
Sources
+1
24h
—
Growth
1d
Active