psql -d appdb -c "ALTER TABLE users DROP COLUMN age;"
Remove a column from a table
Deletes the column and its data; any views or queries referencing it break until updated. The freed space is reclaimed lazily by VACUUM. There is no undo without a prior backup.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.