convert jsonb to text postgres 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