/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

1 vote344 views1 answer
Drop function
SQL
20 votes325 views5 answers
Mysql reset auto increment to 1
SQL
0 vote385 views1 answer
Sql server synonym
SQL
3 votes357 views3 answers
Restart mysql mac
SQL
0 vote346 views2 answers
Sql update multiple tables
SQL
0 vote349 views1 answer
Get the next column of a table in mysql
SQL
0 vote344 views1 answer
Select all columns except one sql
SQL
0 vote325 views1 answer
Mysql show create db
SQL
3 votes342 views2 answers
Sql get month name
SQL
0 vote359 views1 answer
Vbscript connect mssql
SQL

Share