DDL issue - Mailing list pgsql-general

From Rich Shepard
Subject DDL issue
Date
Msg-id 91bda8-3bdb-d93-6c17-41a03a3de27a@appl-ecosys.com
Whole thread Raw
Responses Re: DDL issue
Re: DDL issue
Re: DDL issue
List 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




pgsql-general by date:

Previous
From: Pavel Luzanov
Date:
Subject: Re: Backward compat issue with v16 around ROLEs
Next
From: "David G. Johnston"
Date:
Subject: Re: DDL issue