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:

Data Sharing

  1. Create Share CREATE SHARE my_share; 2. Grant privileges to share GRANT USAGE ON DATABASE my_db TO SHARE my_share; GRANT USAGE ...