Hi Now, there is no native functionality for conversion from json(b) value to some array.
https://stackoverflow.com/questions/76894960/unable-to-assign-text-value-to-variable-in-pgsql/76896112#76896112 It should not be too hard to implement native function jsonb_populate_array jsonb_populate_array(anyarray, jsonb) returns anyarray Usage: select jsonb_populate_array(null::text[], '["cust_full_name","cust_email"]') Comments, notes? Regards Pavel