Page History

...

SELECT
     users.id AS user_id,
     jsonb_extract_path_text (users.jsonb, 'personal', 'lastName') AS requestoruser_last_name,
     jsonb_extract_path_text (users.jsonb, 'personal', 'firstName') AS requestoruser_first_name
FROM
     folio_users.users

...

SELECT
     users.id AS user_id,
     users.jsonb #>> '{personal, lastName}' AS requestoruser_last_name,
     users.jsonb #>> '{personal, firstName}' AS requestoruser_first_name
FROM
     folio_users.users

...

When extracting arrays embedded in text objects, it's usually best to use a "cross join lateral" statement in the FROM stanza. This cross join creates a "json object" that can then be further extracted in the Select stanza. Warning: the records retrieved will only be those that have the array elements you're looking for; records without those elements will drop out.

It's also possible to NOT use a cross join at all, but to nest the json extract statements in one long expression in the Select stanza. However, you lose the ability to include the ordinality of the values extracted.

...