/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 vote98 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote108 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote98 views1 answer
Monthly Birthday SQL Query
SQL
-1 vote77 views1 answer
Mysql if example
SQL
0 vote100 views1 answer
How to connect postgresql database with java
SQL
0 vote104 views1 answer
Sql server user permissions and roles
SQL
0 vote105 views1 answer
Mariadb search columns
SQL
0 vote131 views1 answer
For select oracle
SQL
0 vote100 views1 answer
Sql replace id with name from another table
SQL
0 vote123 views1 answer
Postgresql inheritance
SQL

Share