/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

8 votes444 views1 answer
Mysql dump restore
SQL
4 votes352 views2 answers
Linq join
SQL
2 votes415 views1 answer
Install postgresql centos 5
SQL
1 vote387 views1 answer
Mysql default port
SQL
0 vote331 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote377 views1 answer
Learnxinyminutes sql
SQL
0 vote343 views1 answer
Sql order by number not ordered
SQL
0 vote350 views1 answer
SQL SELECT-Klausel
SQL
3 votes335 views2 answers
Having in mysql
SQL
1 vote346 views1 answer
Create index concurrently postgres
SQL

Share