Re: jsonb

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: jsonb
Date: 2017-11-14 22:09:36
Message-ID: CAHyXU0wXzTvqBrmAu-Q86PG7mtD_+uJuOq7A+1v8AAxH9NtA1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 14, 2017 at 3:32 PM, hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> wrote:
> 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?

not quite following. Can you paste the query you are trying to
execute along with the results vs. expectation? thanks

merlin

In response to

  • jsonb at 2017-11-14 21:32:19 from hmidi slim

Responses

  • Re: jsonb at 2017-11-14 22:30:23 from hmidi slim

Browse pgsql-general by date

  From Date Subject
Next Message hmidi slim 2017-11-14 22:30:23 Re: jsonb
Previous Message hmidi slim 2017-11-14 21:32:19 jsonb