Postgres json to string

Json with postgresql

        
            
        
     SELECT info ->> 'customer' AS customer,
	info -> 'items' ->> 'product' AS product
FROM orders
WHERE CAST ( info -> 'items' ->> 'qty' AS INTEGER) = 2

Source: postgresqltutorial.com

Postgres json to string

SELECT CAST( json_column AS TEXT ) FROM table
or
SELECT json_column::TEXT FROM table

Json array to string in postgresql

SELECT 
	ID
	,(
		SELECT string_agg(trim(JsonString::text, '"'), ', ')
		FROM jsonb_array_elements(JsonData->'Name') JsonString
	) AS StringArray
FROM   tbl_TestJsonArray;

Source: dbrnd.com

Similar codes

4 votes185 views2 answers
Sql offset
SQL
0 vote187 views1 answer
Create table split string function in sql server
SQL
11 votes188 views2 answers
Oracle source code
SQL
2 votes169 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote182 views1 answer
Oracle call a function in a insert statement
SQL
8 votes195 views1 answer
Oracle tablespace datafile max size
SQL
5 votes161 views1 answer
List foreign key oracle
SQL
1 vote167 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
5 votes172 views4 answers
Describe table postgres
SQL
-2 votes200 views2 answers
Union vs union all in sql
SQL