/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

13 votes126 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote142 views1 answer
Ajax error exception handeling
SQL
5 votes131 views1 answer
Invalid column name sql
SQL
0 vote142 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote138 views1 answer
Copy value from one column to another postgres
SQL
0 vote142 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
3 votes96 views4 answers
Mysql delete duplicate rows
SQL
0 vote151 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote134 views2 answers
How to tun mysql on ubunto
SQL
0 vote147 views1 answer
Mysql c commands
SQL

Share