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