Home > mailing lists

[GENERAL] jsonb - Mailing list pgsql-general

From	hmidi slim
Subject	[GENERAL] jsonb
Date	November 15, 2017 03:32:19
Msg-id	CAMsqVxvckCZ1oXgs1xs2gkL6TKvjjeJ3vDQA+FQwv16jJSrT2g@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] jsonb
List	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?

From: Stephen Frost
Date: 15 November 2017, 02:08:17
Subject: Re: [GENERAL] missing public on schema public

From: Merlin Moncure
Date: 15 November 2017, 04:09:36
Subject: Re: [GENERAL] jsonb