Re: How best to create and use associative array type in Postgres?

[Shaozhong SHI <shishaozhong@xxxxxxxxx>]

Have a look at this one.

GitHub - theory/kv-pair: A key/value pair data type for PostgreSQL

There is no documentation on how to use it.

Regards,

David

On Wed, 5 Jan 2022 at 16:24, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Shaozhong SHI <shishaozhong@xxxxxxxxx> writes:
> What do you think this attempt by using create type and create a function?
> Managing Key/Value Pairs in PostgreSQL (justatheory.com)
> <https://justatheory.com/2010/08/postgres-key-value-pairs/>

The date alone should suggest to you that there might be
better ways to do it by now.

                        regards, tom lane