Lookup tables

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Lookup tables
Date: 2025-02-04 14:27:54
Message-ID: 4e7a338-c7d3-e944-20bd-a6e346e175c7@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-general

Should lookup tables have a numeric FK column as well as the description column?

If so, how should I add an FK to the two lookup tables in my database?

TIA,

Rich

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message David G. Johnston 2025-02-04 14:41:37 Re: Lookup tables
Previous Message Sergey Ivanov 2025-02-04 11:37:28 Pgadmin

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-02-04 14:41:37 Re: Lookup tables
Previous Message Pavel Borisov 2025-02-04 11:54:52 Re: Using Expanded Objects other than Arrays from plpgsql