Re: Database schema for "custom fields"

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>
To: Matthias Leisi <matthias@leisi.net>
Cc: pgsql-general@postgresql.org
Date: 2024-09-11T13:24:16Z
Lists: pgsql-general
I'd go with option 2 (jsonb), as it's likely already well supported by your
applications, while the other approaches will require a good bit of
customization. JSONB can be indexed, so performance should be on par with
"traditional" tables.

Cheers,
Greg