postgres json as text code example
Example: postgres json to string
SELECT CAST( json_column AS TEXT ) FROM table
or
SELECT json_column::TEXT FROM table
SELECT CAST( json_column AS TEXT ) FROM table
or
SELECT json_column::TEXT FROM table