MIME-Version: 1.0
References: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
 <CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
 <717426.1728080548@sss.pgh.pa.us>
In-Reply-To: <717426.1728080548@sss.pgh.pa.us>
From: Guillaume Lelarge <guillaume@lelarge.info>
Date: Sat, 5 Oct 2024 09:07:05 +0200
Message-ID: 
 <CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com>
Subject: Re: Same Table Name - 2 Owners
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 Sam Stearns <sam.stearns@dat.com>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>,
 Peter Garza <peter.garza@dat.com>,
	Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="0000000000000f619b0623b57005"
Archived-At: 
 <https://www.postgresql.org/message-id/CAECtzeXkpJrDxRRKHdS%3Dmz5Sp2PoNqO8AOjmNmb1PF5Y%3Dhj0uA%40mail.gmail.com>
Precedence: bulk

--0000000000000f619b0623b57005
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello,

Le sam. 5 oct. 2024 =C3=A0 00:22, Tom Lane <tgl@sss.pgh.pa.us> a =C3=A9crit=
 :

> "David G. Johnston" <david.g.johnston@gmail.com> writes:
> > 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 th=
ey
> > exist in different schemas.
>
> The Oracle case probably also works by putting the tables in different
> schemas.  I recall hearing that Oracle identifies "owner" with
> "schema" much more closely than we do.
>
>
+1

Great article on this topic:
https://stormatics.tech/blogs/transitioning-from-oracle-to-postgresql-under=
standing-the-concept-of-schema

Regards.


--=20
Guillaume.

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

<div dir=3D"ltr"><div>Hello,<br></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">Le=C2=A0sam. 5 oct. 2024 =C3=A0=C2=A000:22,=
 Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt=
; a =C3=A9crit=C2=A0:<br></div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex">&quot;David G. Johnston&quot; &lt;<a href=3D"mailto:david.g.johnston@=
gmail.com" target=3D"_blank">david.g.johnston@gmail.com</a>&gt; writes:<br>
&gt; On Friday, October 4, 2024, Sam Stearns &lt;<a href=3D"mailto:sam.stea=
rns@dat.com" target=3D"_blank">sam.stearns@dat.com</a>&gt; wrote:<br>
&gt;&gt; Is it possible to do this in Postgres?<br>
<br>
&gt; Within PostgreSQL, two objects can have the same name if they are of<b=
r>
&gt; different types (note, relations is a fairly broad type category) or t=
hey<br>
&gt; exist in different schemas.<br>
<br>
The Oracle case probably also works by putting the tables in different<br>
schemas.=C2=A0 I recall hearing that Oracle identifies &quot;owner&quot; wi=
th<br>
&quot;schema&quot; much more closely than we do.<br>
<br></blockquote><div><br></div><div>+1</div><div><br></div><div>Great arti=
cle on this topic:=C2=A0<a href=3D"https://stormatics.tech/blogs/transition=
ing-from-oracle-to-postgresql-understanding-the-concept-of-schema">https://=
stormatics.tech/blogs/transitioning-from-oracle-to-postgresql-understanding=
-the-concept-of-schema</a></div><div><br></div><div>Regards.<br></div></div=
><br clear=3D"all"><br><span class=3D"gmail_signature_prefix">-- </span><br=
><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=
=3D"ltr"><div>Guillaume.<br></div></div></div></div></div></div>

--0000000000000f619b0623b57005--