Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE movies (
    contributors    JSONB
);
INSERT INTO movies (contributors) VALUES('[
  {"last_name": "Robbins", "first_name": "Tim", "age": 61},
  {"last_name": "Freeman", "first_name": "Morgan", "age": 83}
]');
1 rows affected

ALTER TABLE movies ADD COLUMN search TSVECTOR
    GENERATED ALWAYS AS (TO_TSVECTOR('simple',
        contributors /* need help here 🙏 */
    )) STORED;
SELECT search FROM movies; /* Desired output: 'freeman':2 'robbin':1 */


search


'freeman':5 'morgan':7 'robbins':1 'tim':3