/SQL/Postgresql add not null constraint

Postgresql add not null constraint

Postgres add not null to existing column

ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;

3

Postgresql add not null constraint

alter table users alter column email set not null;

2

Source: popsql.com

Similar codes

0 vote152 views1 answer
Sql insert query list of dictionaries
SQL
0 vote128 views1 answer
Flask sqlalchemy decimal
SQL
0 vote126 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote126 views1 answer
Mysql search multiple tables
SQL
3 votes155 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote135 views1 answer
Mysql order by rand limit 1 really slow
SQL
-1 vote119 views1 answer
Add column alter table default value
SQL
0 vote122 views2 answers
Mysql two column combination unique
SQL
0 vote129 views1 answer
Show function mysql
SQL
1 vote127 views4 answers
Psql check tables command
SQL

Share