I just checked operators. I could not find any operator to set a new value
given a key.
Regards,
David
On Wed, 5 Jan 2022 at 13:22, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
wrote:
> On 1/5/22 14:17, Shaozhong SHI wrote:
> > Any examples in Postgres to create a dictionary type to store and access
> > key value pairs?
> >
>
> I'd say JSONB can be used as an associative array, and e.g. in Python
> can map to dict data type.
>
>
> regards
>
> --
> Tomas Vondra
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>