Postgres Pro
Downloads
Home   >   mailing lists

Re: How best to create and use associative array type in Postgres? - Mailing list pgsql-general

From Tom Lane
Subject Re: How best to create and use associative array type in Postgres?
Date
Msg-id 41274.1641394465@sss.pgh.pa.us
Whole thread Raw
In response to How best to create and use associative array type in Postgres?  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: How best to create and use associative array type in Postgres?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view 
Shaozhong SHI <shishaozhong@gmail.com> writes:
> How best to create and use associative array type in Postgres?

I think the closest thing you'd find to that is jsonb, or
contrib/hstore if you'd like something with a bit less complexity.
The notation is unlikely to look much like Oracle, but they
both have the ability to store sets of key/value pairs.

https://www.postgresql.org/docs/current/datatype-json.html
https://www.postgresql.org/docs/current/hstore.html

            regards, tom lane

pgsql-general by date:

Previous
From: Thomas Michael Engelke
Date:
Subject: Replicate consistent snapshot to a second PG instance using FDWs
Next
From: Shaozhong SHI
Date:
Subject: Re: How best to create and use associative array type in Postgres?