/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 vote126 views1 answer
Procedures and functions in pl/sql
SQL
1 vote172 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
4 votes157 views1 answer
Add constraint fk
SQL
0 vote178 views1 answer
Create-table-with-index-organization
SQL
7 votes191 views1 answer
Xampp reset mysql
SQL
2 votes200 views1 answer
How to delete all duplicate items in mysql
SQL
14 votes184 views3 answers
SQL trim
SQL
0 vote223 views1 answer
Postgresql print variable
SQL
0 vote205 views1 answer
Display all node label neo4j
SQL
0 vote169 views1 answer
Convert .mdf to .bak
SQL

Share