Re: Lookup tables
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-02-04T15:05:20Z
Lists: pgsql-general
On Tue, 4 Feb 2025, Ron Johnson wrote: > Does your lookup table just have one column? (That's what your question > seems to imply, but that makes no sense, since the whole point of a lookup > table is to store some sort of a code in the "child" table instead of the > whole text of the description.) Ron, Yes, each has a single column of type names, industrytypes and statustypes. I've always used the descriptive names in queries. Rich