Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sosoi-00EVnO-T8
	for pgsql-general@arkaria.postgresql.org; Thu, 12 Sep 2024 23:01:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sosoi-002pp5-DI
	for pgsql-general@arkaria.postgresql.org; Thu, 12 Sep 2024 23:01:36 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <rshepard@appl-ecosys.com>)
	id 1sosoi-002pox-1Q
	for pgsql-general@lists.postgresql.org; Thu, 12 Sep 2024 23:01:36 +0000
Received: from mail.appl-ecosys.com ([50.126.108.78])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <rshepard@appl-ecosys.com>)
	id 1sosoe-000tEE-9q
	for pgsql-general@postgresql.org; Thu, 12 Sep 2024 23:01:35 +0000
Received: from salmo.appl-ecosys.com (salmo.appl-ecosys.com [192.168.55.1])
	by mail.appl-ecosys.com (Postfix) with ESMTP id 060F42A14D6
	for <pgsql-general@postgresql.org>; Thu, 12 Sep 2024 16:01:31 -0700 (PDT)
Date: Thu, 12 Sep 2024 16:01:30 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
Reply-To: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Subject: DDL issue
Message-ID: <91bda8-3bdb-d93-6c17-41a03a3de27a@appl-ecosys.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/91bda8-3bdb-d93-6c17-41a03a3de27a%40appl-ecosys.com>
Precedence: bulk

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