On Tue, 4 Feb 2025, Rob Sargent wrote:
I would definitely add an Id for each of the looked up values. The code can use the Id (for the join or lookup) and the string value can safely be changed (think typo) without ripple effect. It also prevents other tables from referencing the lookup witrh bogus values (those not in the lookup table) Unless your lookup tables are huge I would create a new table matching your current table but with an identity column and load from you original table. https://www.postgresql.org/docs/current/ddl-identity-columns.html
Thanks, Rob. Each lookup table has only a very few rows, I'll make new tables today. Regards, Rich
