0
I have a type column jsonb
that stores objects in an array.
I can get the key template
of all index objects 0
thus:
psql=# select data->'components'->0->'template' as template from page;
returning:
template
-------------------------------------
"nome-do-template"
//etc
(100 rows)
How can I get the key template
of all objects at the same time, without specifying the index?
EDIT: example of stored array:
[
{
"type": "feed",
"template": "_vertical-content",
},
{
"type": "feature",
"template": "_single-content",
}
]