| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Create and access a dictionary type |
| Date: | 2022-01-05 16:35:15 |
| Message-ID: | bacb43b9-ec26-1adc-8334-dc2e74210c96@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/5/22 17:24, Ron wrote:
> 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?"
>
Well, yes - you can always decompose the dict and store it in an EAV,
but sometimes it's more convenient to just use "nested" dictionary at
the row level. Which is what a JSONB column does.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2022-01-05 16:37:14 | Re: Create and access a dictionary type |
| Previous Message | Ron | 2022-01-05 16:24:47 | Re: Create and access a dictionary type |