Answers for "add default value to an existing column postgresql"

postgresql change default value

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

Posted by: Guest on March-22-2020

postgresql default value

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric DEFAULT 9.99
);

Posted by: Guest on September-23-2021

Code answers related to "add default value to an existing column postgresql"