/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

3 votes151 views1 answer
Create a table with an id in mysql
SQL
2 votes141 views1 answer
Sql server find table name
SQL
8 votes142 views3 answers
Postgresql connection string c#
SQL
0 vote161 views1 answer
Sql query to find duplicate email address
SQL
0 vote149 views4 answers
User defined function sql
SQL
0 vote149 views1 answer
Oracle list dblink
SQL
0 vote142 views1 answer
If null don't update
SQL
1 vote164 views1 answer
Oracle sql pad left zeros
SQL
10 votes148 views2 answers
Oracle alter sequence nextval
SQL
0 vote159 views1 answer
Insert using condition postgres
SQL

Share