Answers for "how to create a new column in table and set the default table postgresql"

postgresql change default value

ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';

Posted by: Guest on March-22-2020

Postgres: Create Column add constraint to the column with Query Output

ALTER TABLE customers 
ADD COLUMN contact_name VARCHAR NOT NULL;

Posted by: Guest on December-02-2020

Code answers related to "how to create a new column in table and set the default table postgresql"