/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 vote187 views1 answer
Sql to excel pgadmin
SQL
0 vote140 views1 answer
Cast for print sql
SQL
0 vote140 views1 answer
IIF
SQL
0 vote146 views1 answer
Mysql bash execute sql file
SQL
1 vote160 views1 answer
Psql view enum values
SQL
0 vote161 views1 answer
Sql statement show all emails with dome
SQL
0 vote152 views1 answer
Apex for oracle 11g
SQL
23 votes169 views2 answers
Query to delete a database in mysql
SQL
3 votes165 views2 answers
Search text in all sql server stored procedure
SQL
1 vote164 views1 answer
Mysql query bulk insert
SQL

Share