Re: jsonb

On 11/14/2017 2:30 PM, hmidi slim wrote:
> I'm trying to use the function to_jsonb and create the name:
> to_jsonb ('{"key1":" ' || 'text1' || '","key2":" ' || 'text2' || '"}');
> But after that I used Objection.js ORM to get data using the query:
> Product.query().where('id',1).then(prod => {console.log(prod)})
> I think that the problem maybe with the usage of to_jsonb function,
> maybe I miss something. But when I fetch the data with the ORM I found
> that the type was a string and not a jsonb
>

never heard of your ORM... does it even know what postgres jsonb is ?  
do you know what actual SQL query that piece of ORMism generates ?

--
john r pierce, recycling bits in santa cruz