如何将列添加到不允许空值的Postgresql数据库？

ALTER TABLE your_table_name ADD COLUMN new_column_name data_type;

ALTER TABLE users ADD COLUMN age INTEGER;

UPDATE your_table_name SET new_column_name = default_value;

UPDATE users SET age = 0;

ALTER TABLE your_table_name ALTER COLUMN new_column_name SET NOT NULL;

ALTER TABLE users ALTER COLUMN age SET NOT NULL;