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