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@sss.pgh.pa.us > <mailto:tgl@sss.pgh.pa.us>> wrote: > > Shaozhong SHI <shishaozhong@gmail.com > <mailto:shishaozhong@gmail.com>> 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@aklaver.com
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных