On Thu, Nov 23, 2017 at 4:45 AM, support-tiger <support@xxxxxxxxxxxxxxx> wrote:
> is there a way to update a single field in jsonb without replacing the
> entire json document - couldn't find an example
>
> for example
>
> create table test (id primary key, data jsonb);
>
> insert into test ({"name":"bill", "age":29});
>
> ?? update test set data->age = 30
update test set data = jsonb_set(data, '{age}', '30'::jsonb);
>
>
> --
> Support Dept
> Tiger Nassau, Inc.
> www.tigernassau.com
> 406-624-9310
>
>
>
