PostgreSQL JSONB (Selecting value returns value with quotes, "value")

Question

Have a JSONB column with data like this:

{"title": "Some book!", "uniqueId": "11264299-2543-566"}

When I try to select the values, they are returned with double quotes surrounding them...

SELECT 'Some book!', json_data->'title' FROM myJsonTable

Returns:

Some book!      "Some book!"

on phone: SELECT 'Some book!', json_data->>'title' FROM myJsonTable; notice the double arrow, single -> returns type JSON where strings are quoted. — Lucas
– Lucas, Commented Mar 19, 2015 at 2:29

Brad · Accepted Answer · 2015-03-19 03:27:34Z

7

Instead of using json_data->'title', I needed to use jsonb_extract_path_text(json_data, 'title')...

Edit: Or as Lucas said in the comment, use json_data->>'title'...

answered Mar 19, 2015 at 2:22

Brad

1,6844 gold badges21 silver badges37 bronze badges

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

1 Answer 1