/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 vote125 views1 answer
Insert data from stored procedure into table
SQL
0 vote216 views3 answers
Insert or ignore postgres
SQL
0 vote133 views1 answer
Oracle drop default value
SQL
0 vote133 views1 answer
Access mysql database docker container shell
SQL
2 votes162 views2 answers
Postgres set user as superuser
SQL
1 vote136 views1 answer
OstgreSQL version
SQL
0 vote143 views1 answer
Intellij idea add mysql connector
SQL
-1 vote131 views3 answers
SQL to LINQ converter
SQL
2 votes133 views2 answers
Oracle multiple insert
SQL
0 vote218 views3 answers
Osx stop mysql service
SQL

Share