Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TYPE pencil_count AS(
    pencil_color varchar(30),
    count integer
);

CREATE TABLE pencils(id serial, pencils_ pencil_count[]);

CREATE TYPE

CREATE TABLE

INSERT INTO pencils(pencils_) 
VALUES('{"(\"blue\",5)","(\"red\",2)"}');

INSERT 0 1

SELECT *
FROM pencils

id
pencils_

1
{"(blue,5)","(red,2)"}

SELECT 1