/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

7 votes220 views3 answers
Foreign key oracle
SQL
0 vote181 views1 answer
Select mysql limit to 2 decimal places
SQL
4 votes199 views2 answers
How to delete row in sql
SQL
37 votes346 views3 answers
Sql check duplicate value in column
SQL
0 vote256 views1 answer
Traccar mysql
SQL
3 votes209 views3 answers
How to set up an auto incrementing id db browser
SQL
3 votes237 views2 answers
How to force truncate a table in mysql
SQL
1 vote213 views1 answer
Load sql into mamp
SQL
25 votes211 views3 answers
Mysql command show tables
SQL
23 votes223 views1 answer
How remove column in mysql
SQL

Share