By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
SELECT concat('(', string_agg(value, ', '), ')')
FROM jsonb_each_text('{"userid":"test","rolename":"Root","loginerror":0,"email":"superadmin@ae.com","thirdpartyauthenticationkey":{}}'::jsonb) jet (key,
value);
| concat |
|---|
| (superadmin@ae.com, test, Root, 0, {}) |
SELECT 1