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>
 <CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com>
In-Reply-To: 
 <CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com>
From: Sam Stearns <sam.stearns@dat.com>
Date: Mon, 7 Oct 2024 08:36:30 -0700
Message-ID: 
 <CAN6TVjn8oA93aykMi4HqupxOTqqPKmJefNdqFO0o1Urj=m-TzA@mail.gmail.com>
Subject: Re: Same Table Name - 2 Owners
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
        "David G. Johnston" <david.g.johnston@gmail.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="0000000000008e02e30623e4c961"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVjn8oA93aykMi4HqupxOTqqPKmJefNdqFO0o1Urj%3Dm-TzA%40mail.gmail.com>
Precedence: bulk

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

Thank you all for the help!  We're testing this out now with some Oracle
imports into Postgres.

Sam

On Sat, Oct 5, 2024 at 12:07=E2=80=AFAM Guillaume Lelarge <guillaume@lelarg=
e.info>
wrote:

> Hello,
>
> Le sam. 5 oct. 2024 =C3=A0 00:22, Tom Lane <tgl@sss.pgh.pa.us> a =C3=A9cr=
it :
>
>> "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
>> they
>> > 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-und=
erstanding-the-concept-of-schema
>
> Regards.
>
>
> --
> Guillaume.
>


--=20

*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=3Demail&utm_source=3DDAT_email_signature_l=
ink>

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

<div dir=3D"ltr">Thank you all for the help!=C2=A0 We&#39;re testing this o=
ut now with some Oracle imports into Postgres.<div><br></div><div>Sam</div>=
</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">=
On Sat, Oct 5, 2024 at 12:07=E2=80=AFAM Guillaume Lelarge &lt;<a href=3D"ma=
ilto:guillaume@lelarge.info">guillaume@lelarge.info</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>He=
llo,<br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmai=
l_attr">Le=C2=A0sam. 5 oct. 2024 =C3=A0=C2=A000:22, Tom Lane &lt;<a href=3D=
"mailto:tgl@sss.pgh.pa.us" target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; a =
=C3=A9crit=C2=A0:<br></div><blockquote class=3D"gmail_quote" style=3D"margi=
n: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@gmai=
l.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" target=
=3D"_blank">https://stormatics.tech/blogs/transitioning-from-oracle-to-post=
gresql-understanding-the-concept-of-schema</a></div><div><br></div><div>Reg=
ards.<br></div></div><br clear=3D"all"><br><span class=3D"gmail_signature_p=
refix">-- </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></di=
v></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><p style=3D"color:rgb(0,0,0);font-family:Gotham,&quot;Helvet=
ica Neue&quot;,Helvetica,Arial,sans-serif;font-size:0.8rem;line-height:1.2r=
em"><strong style=3D"font-size:0.9rem;color:rgb(51,51,51)">Samuel Stearns</=
strong><br><span style=3D"color:rgb(102,102,102)">Lead Database Administrat=
or<br><strong>c:</strong>=C2=A0971 762 6879=C2=A0<span style=3D"color:rgb(1=
47,149,152)">|</span>=C2=A0<strong>o:</strong>=C2=A0503 672 5115=C2=A0<span=
 style=3D"color:rgb(147,149,152)">|</span>=C2=A0DAT.com</span></p><div styl=
e=3D"color:rgb(0,0,0);font-family:&quot;Times New Roman&quot;;font-size:med=
ium"><a href=3D"https://www.dat.com/?utm_medium=3Demail&amp;utm_source=3DDA=
T_email_signature_link" target=3D"_blank"><img src=3D"https://www.dat.com/w=
p-content/uploads/media/images/global/emails/signature2/dat_126.png" alt=3D=
"DAT" width=3D"126" height=3D"54"></a></div></div></div>

--0000000000008e02e30623e4c961--