Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR JAVASCRIPT

json array to string in postgresql

	SELECT string_agg(trim(tdata::text, '"'), ', ') from jsonb_array_elements(CAST('[1 , 2]' as jsonb)) tdata
 
PREVIOUS NEXT
Tagged: #json #array #string #postgresql
ADD COMMENT
Topic
Name
9+9 =