Re: Lookup tables - Mailing list pgsql-general

From Rich Shepard
Subject Re: Lookup tables
Date
Msg-id 50498443-1599-c62f-b3b7-485828c54e22@appl-ecosys.com
Whole thread Raw
In response to Re: Lookup tables  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Lookup tables
List 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



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Lookup tables
Next
From: Rich Shepard
Date:
Subject: Re: Lookup tables