| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Lookup tables |
| Date: | 2025-02-04 14:59:48 |
| Message-ID: | CANzqJaC3FeJCSy5EUw9VzunBgG3EK6e9=QzUk9wkF8o1Y5iToA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
On Tue, Feb 4, 2025 at 9:28 AM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:
> Should lookup tables have a numeric FK column as well as the description
> column?
>
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.)
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2025-02-04 15:04:54 | Re: Lookup tables |
| Previous Message | David G. Johnston | 2025-02-04 14:59:09 | Re: Lookup tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2025-02-04 15:04:54 | Re: Lookup tables |
| Previous Message | David G. Johnston | 2025-02-04 14:59:09 | Re: Lookup tables |