/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 vote276 views1 answer
Recursive query herarchical data sql server
SQL
10 votes309 views2 answers
Oracle alter sequence nextval
SQL
0 vote314 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
23 votes334 views5 answers
Sql substring
SQL
5 votes274 views1 answer
Oracle list packages
SQL
1 vote283 views3 answers
Postgresql connect to database
SQL
1 vote276 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote286 views1 answer
Datagrip exec
SQL
2 votes344 views3 answers
How to replace null values in sql
SQL
0 vote290 views2 answers
Getting customers with no orders sql
SQL

Share