How to update a postgres jsonb field using eloquent models

Hello may I have some help on this?

How to update a postgres jsonb field using eloquent models

Mar 6 '20 Comments: 3 Answers: 0

1

I have the following table in my postgresql database:

OOSama:
ID: AUTOINCREMENT BIGINT
NAME: VARCHAR(255)
NANI_WO_SUKI: JSONB

The NANI_WO_SUKI fields can contain the follwowing JSON:

{
  "kodomo":false,
  "dagashi":true,
  "kurosakikun":true
}

So I want to be able to update it without using raw SQL query. So I made the following model:

…

Open Full Question