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-admin-owner+archive@lists.postgresql.org>)
	id 1swqbk-006MFy-7G
	for pgsql-admin@arkaria.postgresql.org; Fri, 04 Oct 2024 22:17:08 +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-admin-owner+archive@lists.postgresql.org>)
	id 1swqbj-0072cj-GI
	for pgsql-admin@arkaria.postgresql.org; Fri, 04 Oct 2024 22:17:07 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1swqbj-0072cb-4o
	for pgsql-admin@lists.postgresql.org; Fri, 04 Oct 2024 22:17:07 +0000
Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1swqbg-002W0B-K9
	for pgsql-admin@lists.postgresql.org; Fri, 04 Oct 2024 22:17:05 +0000
Received: by mail-oo1-xc36.google.com with SMTP id
 006d021491bc7-5e1b6e8720dso1362682eaf.0
        for <pgsql-admin@lists.postgresql.org>;
 Fri, 04 Oct 2024 15:17:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1728080224; x=1728685024;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:references:in-reply-to
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=Iwu0TdP0lCq+mRIeRI+IC9ULG75AWb36uaSY9gAyajY=;
        b=PazVCS3q1YFhRohNHUijG/JKXvTXCVCUZgZ9LoHHhcNAYZTZTWpy3/PrybTfiqpI8o
         9toTa3Nm2YYK02zBQbtvhbXF7kPhj8+T+oAuRAaJqKNqryHt3dWcDq0L2CnyizZetWUu
         GY8w3F+kBMUDxcRNcVK0dKTIdVuKz3RsMYFu5T84k9hFCHqlDlILtHNLm9jpkNHj2tjA
         cADi8EWreHrWRUf+LDZxfHbjtQdUf26IhvLdTJ4mcJMm1ljnm+kO52NakC0g4RWEciy5
         3wAgHUqTnlI8F7J9IJwbrCon33imRrIpRhFQ7aL4UjNRJ1BKTTvzx+3V8JownLxkCdKm
         FQwA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1728080224; x=1728685024;
        h=cc:to:subject:message-id:date:from:references:in-reply-to
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=Iwu0TdP0lCq+mRIeRI+IC9ULG75AWb36uaSY9gAyajY=;
        b=F9tI3kK6DWdY1h0pmJoWXswC37t8dyw2kLMg9PjknF01kMjDmwtF062WyY7qO5rmlU
         FqrzN3jy2jQHxlzsvKfZ4GR7DpsnykBAQGB2Buraj//fGdmoc34CvshekbdRh2cBuZUt
         fdHod8LjWBSouo8zr+xRfuwaD7ebRyZJBo/5pBA/NCsmsmflwq7BcrM/myS2SHE45qQr
         B1c8+ymELKsfez++Dzc7/lWNAnos5a8jJRmMkpLE5BG70bPTaF/lVfHHffMGbmYV/t6S
         hL9Pez+Kg5zg4C/r9CciG0Ogzd/Th8Of60NO4rQAaG1ycGXnBwjd+T6ahuIgDaQ/DciS
         tViQ==
X-Gm-Message-State: AOJu0YzcLbfCiAfSmOYocnNVAOKYoi7wU9gURo0495qYe4kj/GZSkMnH
	2z5rC6HM4YQcA8/tJmMWKl3oqVVomhKEPQRs+xVrtIzVTT+Z6oxRo1Vj+QQ/RmQzf7+IMQWpX20
	toNdTVd6JfAFix9eJeVmsEhI6/KQ=
X-Google-Smtp-Source: 
 AGHT+IEwZzxAm8kD2caSzt0vK1OBMLp7Z2C+5rK+2z9rV8FlkyATZ/WvwWOiBTCFnxlkGnT6bXBwIm9rrg+KNgRQYw0=
X-Received: by 2002:a05:6870:f150:b0:270:74f2:8e97 with SMTP id
 586e51a60fabf-287c1dadc9cmr3892362fac.15.1728080223851; Fri, 04 Oct 2024
 15:17:03 -0700 (PDT)
MIME-Version: 1.0
Received: by 2002:ac9:5992:0:b0:557:c384:fb61 with HTTP; Fri, 4 Oct 2024
 15:17:03 -0700 (PDT)
In-Reply-To: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
References: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 4 Oct 2024 15:17:03 -0700
Message-ID: 
 <CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
Subject: Re: Same Table Name - 2 Owners
To: Sam Stearns <sam.stearns@dat.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
 Peter Garza <peter.garza@dat.com>,
	Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="000000000000e2db6f0623ae070f"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ%40mail.gmail.com>
Precedence: bulk

--000000000000e2db6f0623ae070f
Content-Type: text/plain; charset="UTF-8"

On Friday, October 4, 2024, Sam Stearns <sam.stearns@dat.com> wrote:
>
> Is it possible to do this in Postgres?
>

Within PostgreSQL, two objects can have the same name if they are of
different types (note, relations is a fairly broad type category) or they
exist in different schemas.

David J.

--000000000000e2db6f0623ae070f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, October 4, 2024, Sam Stearns &lt;<a href=3D"mailto:sam.stearns@d=
at.com">sam.stearns@dat.com</a>&gt; wrote:<blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><d=
iv dir=3D"ltr"><div>Is it possible to do this in Postgres?<div dir=3D"ltr" =
class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"lt=
r"><div style=3D"color:rgb(0,0,0);font-family:&quot;Times New Roman&quot;;f=
ont-size:medium"></div></div></div></div></div></blockquote><div><br></div>=
<div>Within PostgreSQL, two objects can have the same name if they are of d=
ifferent types (note, relations is a fairly broad type category) or they ex=
ist in different schemas.</div><div><br></div><div>David J.</div>

--000000000000e2db6f0623ae070f--