Re: Lookup tables

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Lookup tables
Date: 2025-02-04 15:05:20
Message-ID: 50498443-1599-c62f-b3b7-485828c54e22@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support 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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rich Shepard 2025-02-04 15:08:41 Re: Lookup tables
Previous Message David G. Johnston 2025-02-04 15:04:54 Re: Lookup tables

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2025-02-04 15:08:41 Re: Lookup tables
Previous Message David G. Johnston 2025-02-04 15:04:54 Re: Lookup tables