MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Fri, 4 Oct 2024 15:09:59 -0700
Message-ID: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
Subject: Same Table Name - 2 Owners
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Peter Garza <peter.garza@dat.com>, Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="00000000000044a0490623adefa8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVj%3DTV0jpSN_zJ7uHZr%2BJQ%3DN8j8vRduxSNRdxepfDizncpw%40mail.gmail.com>
Precedence: bulk

--00000000000044a0490623adefa8
Content-Type: text/plain; charset="UTF-8"

Howdy,

In Oracle, I have a table name that is the same name between 2 different
owners but completely different DDL:


*SQL> select owner, object_name, object_type from dba_objects where
object_name = 'SUBSCRIPTIONS' and object_type = 'TABLE';OWNER
 OBJECT_NAME          OBJECT_TYPE---------- --------------------
-----------------------INTERFACE  SUBSCRIPTIONS        TABLEORACLE
SUBSCRIPTIONS        TABLESQL>*


Is it possible to do this in Postgres?

-- 

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

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

<div dir=3D"ltr">Howdy,<div><br></div><div>In Oracle, I have a table name t=
hat is the same name between 2 different owners but completely different DD=
L:</div><div><br></div><div><br></div><div><i>SQL&gt; select owner, object_=
name, object_type from dba_objects where object_name =3D &#39;SUBSCRIPTIONS=
&#39; and object_type =3D &#39;TABLE&#39;;<br><br>OWNER =C2=A0 =C2=A0 =C2=
=A0OBJECT_NAME =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0OBJECT_TYPE<br>---------- =
-------------------- -----------------------<br>INTERFACE =C2=A0SUBSCRIPTIO=
NS =C2=A0 =C2=A0 =C2=A0 =C2=A0TABLE<br>ORACLE =C2=A0 =C2=A0 SUBSCRIPTIONS =
=C2=A0 =C2=A0 =C2=A0 =C2=A0TABLE<br><br>SQL&gt;</i></div><div><br></div><di=
v><br></div><div>Is it possible to do this in Postgres?<br clear=3D"all"><d=
iv><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div =
dir=3D"ltr"><p style=3D"color:rgb(0,0,0);font-family:Gotham,&quot;Helvetica=
 Neue&quot;,Helvetica,Arial,sans-serif;font-size:0.8rem;line-height:1.2rem"=
><strong style=3D"font-size:0.9rem;color:rgb(51,51,51)">Samuel Stearns</str=
ong><br><span style=3D"color:rgb(102,102,102)">Lead Database Administrator<=
br><strong>c:</strong>=C2=A0971 762 6879=C2=A0<span style=3D"color:rgb(147,=
149,152)">|</span>=C2=A0<strong>o:</strong>=C2=A0503 672 5115=C2=A0<span st=
yle=3D"color:rgb(147,149,152)">|</span>=C2=A0DAT.com</span></p><div style=
=3D"color:rgb(0,0,0);font-family:&quot;Times New Roman&quot;;font-size:medi=
um"><a href=3D"https://www.dat.com/?utm_medium=3Demail&amp;utm_source=3DDAT=
_email_signature_link" target=3D"_blank"><img src=3D"https://www.dat.com/wp=
-content/uploads/media/images/global/emails/signature2/dat_126.png" alt=3D"=
DAT" width=3D"126" height=3D"54"></a></div></div></div></div></div>

--00000000000044a0490623adefa8--