Personal tools
You are here: Home Les outils logiciels SGBD postgresql postgresql - add a constraint to a column

postgresql - add a constraint to a column

 

 

 

 

alter table bca_bulk_cargo
drop constraint if exists bca_goods_item_number_max_value;

alter table bca_bulk_cargo
add column if not exists bca_goods_item_number integer
constraint bca_goods_item_number_max_value check (bca_goods_item_number between 1 and 99999);

 

 

 

 

Document Actions
« May 2024 »
May
MoTuWeThFrSaSu
12345
6789101112
13141516171819
20212223242526
2728293031