postgres med json

jsonb.sql

insert into artikler(article_type, content)
values (1, '{"articleId": "xyz123",  "meta":{"tag":"bil", "title":"ny elbil", "codes":["a","b"]}}'::jsonb);

select content::text
from artikler;

select content -> 'meta' ->> 'title' as tittel
from artikler
where content -> 'meta' ->> 'tag' = 'bil';

select id, id, jsonb_array_elements(content -> 'meta' -> 'codes')
from artikler
where content @> '{"meta":{"codes":["a"]}}';

create index article_tag_idx on artikler using gin ((content -> 'meta' -> 'tag'));

start_local_db.sh

docker start jsonbtesting || docker run  -e POSTGRES_USER=jsonb_user -e POSTGRES_PASSWORD=dingafu -e POSTGRES_DB=jsonbtesting --name jsonbtesting -dt -p 5432:5432 postgres:15.3