Re: Lookup tables

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Lookup tables
Дата
Msg-id 50498443-1599-c62f-b3b7-485828c54e22@appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Lookup tables  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Lookup tables
Список 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 по дате отправления: