DDL issue

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DDL issue
Date: 2024-09-12 23:01:30
Message-ID: 91bda8-3bdb-d93-6c17-41a03a3de27a@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have one name in the people table who owns 5 different dairies with three
different phone numbers, but all 5 have the the same email address.

The five dairies each has its own name and location while the people table
has five rows with the same last and first names and email address.

Is there a way to have only one entry for the owner in the people table
while related to five different company names? In some industries, such as
dairy farms, this is not an unusual situation.

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-09-12 23:32:25 Re: DDL issue
Previous Message Pavel Luzanov 2024-09-12 22:03:53 Re: Backward compat issue with v16 around ROLEs