On 2019-02-04 05:34, Syed Jafri wrote: > |---------------------|------------------|---------------------|------------------| > | Receiver | Event | Date | Location | > |---------------------|------------------|---------------------|------------------| > | Alpha | 3 | 12 | USA | > |---------------------|------------------|---------------------|------------------| > | Bravo | 3 | 12 | USA | > |---------------------|------------------|---------------------|------------------| > | Charlie | 3 | 12 | USA | > |---------------------|------------------|---------------------|------------------| Please forgive a naive question, but doesn't this simply cry out for a normalization step? EventID Date Location 3 12 USA Receiver EventID Alpha 3 Bravo 3 Charlie 3 If you want to use JSON by any means necessary, perhaps a simpler key/value store is more appropriate than a relational DB like Postgres? -- Please don't Cc: me privately on mailing lists and Usenet, if you also post the followup to the list or newsgroup. To reply privately _only_ on Usenet and on broken lists which rewrite From, fetch the TXT record for no-use.mooo.com.
