postgres: how to select a json column as text

Question

I have a json column, I want to select it as text, like :

select json_to_string(my_json_col) from my_table

How is that done ?

dsh · Accepted Answer · 2014-03-01 03:01:41Z

28

I would try:

SELECT CAST(my_json_col AS VARCHAR) FROM my_table

or

SELECT my_json_cal::varchar FROM my_table

(I haven't worked with JSON in PostgreSQL yet, but the above is how PostgreSQL handles type conversions)

answered Mar 1, 2014 at 3:01

dsh

12.3k3 gold badges37 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1