/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 vote266 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote260 views1 answer
Show indices in mysql table
SQL
0 vote273 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote277 views1 answer
Ms sql database data size
SQL
0 vote292 views1 answer
Is not numeric sql
SQL
0 vote278 views1 answer
Set a value by excuting stored procedure
SQL
1 vote249 views1 answer
Postgresql convert text to float
SQL
0 vote277 views1 answer
Executescalar in sql server
SQL
0 vote264 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote278 views1 answer
Size of all tables in a schema oracle
SQL

Share