jsonb

From: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: jsonb
Date: 2017-11-14 21:32:19
Message-ID: CAMsqVxvckCZ1oXgs1xs2gkL6TKvjjeJ3vDQA+FQwv16jJSrT2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a column name of type 'jsonb' on my table named product. The format
of the column:
name: {"key1": "text1", "key2": "text2"}

When I make a query to fetch data from the table I got this format:
name: '{"key1": "text1", "key2": "text2"}'

Why does postgresql returns the name such as string type and not jsonb? is
it a bug or is there something else to add?

Responses

  • Re: jsonb at 2017-11-14 22:09:36 from Merlin Moncure

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2017-11-14 22:09:36 Re: jsonb
Previous Message Stephen Frost 2017-11-14 20:08:17 Re: missing public on schema public