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.von...@enterprisedb.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 >
