Search Postgresql Archives

Re: Create and access a dictionary type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Create and access a dictionary type
From: Tomas Vondra <tomas.vondra@xxxxxxxxxxxxxxxx>
Date: Wed, 5 Jan 2022 14:22:24 +0100
In-reply-to: <CA+i5JwYG_m7Ka2Sw_p9r5-3LrRqz=4HsuccX-7oz4+SMtbmvhA@mail.gmail.com>
References: <CA+i5JwYG_m7Ka2Sw_p9r5-3LrRqz=4HsuccX-7oz4+SMtbmvhA@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.2.0

On 1/5/22 14:17, Shaozhong SHI wrote:

Any examples in Postgres to create a dictionary type to store and accesskey value pairs?

I'd say JSONB can be used as an associative array, and e.g. in Pythoncan map to dict data type.



regards

--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Create and access a dictionary type
  - From: Ron
- Re: Create and access a dictionary type
  - From: Shaozhong SHI

References:
- Create and access a dictionary type
  - From: Shaozhong SHI

Prev by Date: Re: Postgis - geography function
Next by Date: Re: Create and access a dictionary type
Previous by thread: Create and access a dictionary type
Next by thread: Re: Create and access a dictionary type
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux