如何在postgresql中的列中返回数组/JSON结构？

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    roles INTEGER[]
);

INSERT INTO users (name, roles) VALUES ('Alice', ARRAY[1, 2, 3]);
INSERT INTO users (name, roles) VALUES ('Bob', ARRAY[4, 5]);

SELECT name, roles FROM users;

CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    details JSON
);

INSERT INTO products (name, details) VALUES ('Product A', '{"color": "red", "price": 100}');
INSERT INTO products (name, details) VALUES ('Product B', '{"color": "blue", "price": 200}');

SELECT name, details FROM products;

SELECT * FROM users WHERE roles @> ARRAY[2];

SELECT name, details->>'color' AS color FROM products;

UPDATE users SET roles = array_append(roles, 6) WHERE id = 1;

UPDATE products SET details = jsonb_set(details, '{price}', '300') WHERE id = 1;