Monday, 5 September 2022

Postgresql - ADD/ REMOVE - DEFAULT VALUE FROM A COLUMN

 -- EXAMPLE: MY_TABLE_NAME HAVE A DEFAULT TOTAL OF 0 

ALTER TABLE MY_TABLE_NAME ALTER COLUMN TOTAL_CENTS SET DEFAULT 0;


-- EXAMPLE: MY_TABLE_NAME ARE AVAILABLE BY DEFAULT

ALTER TABLE MY_TABLE_NAME ALTER COLUMN AVAILABLE SET DEFAULT TRUE;

ALTER TABLE MY_TABLE_NAME ALTER COLUMN TOTAL_CENTS DROP DEFAULT;

No comments:

Kiro - Core Features

What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...