CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) UNIQUE,
age INT CHECK (age >= 18)
);
CREATE TABLE products (
id SERIAL PRIMARY KEY,
details JSONB
);
INSERT INTO products (details)
VALUES ('{"name": "Apple", "price": 0.99}');
SELECT details->>'name', details->>'price'
FROM products;
