Re: [GENERAL] jsonb

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [GENERAL] jsonb
Дата
Msg-id CAHyXU0wXzTvqBrmAu-Q86PG7mtD_+uJuOq7A+1v8AAxH9NtA1Q@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] jsonb  (hmidi slim <hmidi.slim2@gmail.com>)
Ответы Re: [GENERAL] jsonb  (hmidi slim <hmidi.slim2@gmail.com>)
Список pgsql-general
On Tue, Nov 14, 2017 at 3:32 PM, hmidi slim <hmidi.slim2@gmail.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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: hmidi slim
Дата:
Сообщение: [GENERAL] jsonb
Следующее
От: hmidi slim
Дата:
Сообщение: Re: [GENERAL] jsonb