Price

Create custom type

CREATE TYPE price AS ("amount" float, "currency" char(3));
CREATE TYPE vat AS ("base" float, "amount" float, "rate" smallint);

Use the type in table column

CREATE TABLE sandbox.test (
    id serial,
    "price" price,
    "vat" vat
);

Insert into the column

INSERT INTO sandbox.test (price,vat) SELECT ROW(1.254, 'EUR')::price, ROW(100,21,21)::vat