CODE EXAMPLE FOR SQL

postgresql default value

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