Re: Create and access a dictionary type

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Create and access a dictionary type
Date: 2022-01-05 16:24:47
Message-ID: def33987-b02b-c87d-f854-444989b80610@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/5/22 7:22 AM, Tomas Vondra 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.

The question confuses me.  Why isn't "create a table with Primary Key" the
answer to "Any examples in Postgres to create a dictionary type to store and
access key value pairs?"

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2022-01-05 16:35:15 Re: Create and access a dictionary type
Previous Message Tom Lane 2022-01-05 16:24:16 Re: How best to create and use associative array type in Postgres?