/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 vote457 views1 answer
Athena query timestamp greater than
SQL
0 vote251 views1 answer
Sql use with to get value counts and percentages
SQL
3 votes245 views1 answer
Oracle sleep
SQL
5 votes238 views1 answer
Oracle ora-00054 resource busy
SQL
2 votes224 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote242 views1 answer
SQL FROM-Klausel
SQL
1 vote223 views1 answer
Mysql count words
SQL
0 vote251 views1 answer
SQL Server date literal
SQL
4 votes247 views1 answer
Mysql ip address data type
SQL
16 votes236 views6 answers
Mysql find and replace
SQL

Share