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.vondra@xxxxxxxxxxxxxxxx> 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
