SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE products ( Id uuid primary key default uuid_generate_v4(), name text, parameters json ); INSERT INTO products (name, parameters) VALUES ( 'Брюки мужские', '{"material": "хлопок", "producer": "Глория джинс", "colors": ["чёрный", "синий", "белый"], "size": ["S","M","L"]}' ), ( 'Одеколон "Русский лес"', '{"producer": "Новая Заря", "volume": [50, 100]}' ); SELECT name, p.* FROM products, json_to_record(parameters) as p(material text, producer text, colors text[], size text[]); SELECT row_to_json(products.*) FROM products; SELECT name, parameters->>'producer' as producer, parameters->>'material' as material, parameters#>>'{colors, 1}' as color1 FROM products; SELECT * FROM products WHERE parameters->>'volume' is not null;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear