psql -d appdb -c "ALTER TABLE users ALTER COLUMN email SET NOT NULL;"

Category: Databases & SQL

psql -d appdb -c "ALTER TABLE users ALTER COLUMN email SET NOT NULL;"

Enforce NOT NULL on a column

Forbids NULL values in email from now on. PostgreSQL verifies existing rows and may rewrite the table, so test on large tables. DROP NOT NULL reverses the constraint.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.