On 1/5/22 12:26, Shaozhong SHI wrote:
Have a look at this one.
GitHub - theory/kv-pair: A key/value pair data type for PostgreSQL
<https://github.com/theory/kv-pair>
There is no documentation on how to use it.
Why use it when you have:
https://www.postgresql.org/docs/current/datatype-json.html
Or if you want something simpler:
https://www.postgresql.org/docs/current/hstore.html
Regards,
David
On Wed, 5 Jan 2022 at 16:24, Tom Lane <tgl@xxxxxxxxxxxxx
<mailto:tgl@xxxxxxxxxxxxx>> wrote:
Shaozhong SHI <shishaozhong@xxxxxxxxx
<mailto: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
<http://justatheory.com>)
> <https://justatheory.com/2010/08/postgres-key-value-pairs/
<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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
