Re: Create and access a dictionary type

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Create and access a dictionary type
Date: 2022-01-05 13:36:19
Message-ID: CA+i5JwYxD6ND8+WW+vLkO_9sst2wjbYJ6LtZxcZ=jOgm9qqiwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Michael Engelke 2022-01-05 14:12:14 Replicate consistent snapshot to a second PG instance using FDWs
Previous Message Tomas Vondra 2022-01-05 13:22:24 Re: Create and access a dictionary type