/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 vote236 views1 answer
Create table sql generator
SQL
0 vote263 views1 answer
Show all sequences postgres
SQL
4 votes247 views6 answers
List all tables in postgres
SQL
0 vote224 views1 answer
Mysql procedure between two tables
SQL
0 vote236 views1 answer
Drop procedure sql
SQL
1 vote354 views3 answers
Uninstall postgresql mac
SQL
36 votes243 views6 answers
Delete from where sql
SQL
2 votes235 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote217 views1 answer
Postgres format date in select
SQL
0 vote231 views1 answer
Insert overwrite table in mysql in nifi
SQL

Share