Postgres Pro
Downloads
Home   >   mailing lists

Re: Lookup tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: Lookup tables
Date
Msg-id CAKFQuwYj=6U6CrsREaGzXV8TzprdTuSfZz+UijWBq39cdtbN3Q@mail.gmail.com
Whole thread Raw
In response to Re: Lookup tables  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Lookup tables
List pgsql-general
Tree view
On Tuesday, February 4, 2025, Rich Shepard <rshepard@appl-ecosys.com> wrote:

I want to replace the old lookup table (with no FK) with this one.

Is the use of FK here intentional or a typo?  Because everything written so far leads me to believe it should be PK.  Pri,are key is the unique side, Foreign key is the usage side.

David J.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Lookup tables
Next
From: Rich Shepard
Date:
Subject: Re: Lookup tables