On Tue, Nov 14, 2017 at 3:32 PM, hmidi slim <hmidi.slim2@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general