SELECT string_agg(trim(tdata::text, '"'), ', ') from jsonb_array_elements(CAST('[1 , 2]' as jsonb)) tdata.
postgresql-jsonb-to-string
text, Does the string exist as a top-level key within the JSON value? '{"a":1, "b":2}'::jsonb ? 'b' ?| text[], Do any of these array strings exist as top-level keys? '{"a":1 ... 939c2ea5af
postgresql jsonb string, postgresql jsonb string to text, postgresql jsonb string to int, postgresql jsonb contains string, postgresql cast jsonb to string, postgresql jsonb array to string, postgresql json string to jsonb, postgresql replace string in json, postgresql json find string, postgresql update jsonb string, postgres jsonb string contains, postgres jsonb string to int, postgresql json string, postgresql json stringify, postgresql json string to array, postgresql json string to table, postgresql json string to date, postgresql json string query
Comments