Message-ID: <caf17507-f447-2b52-1b88-5bcdcfd8621a@jakobs.com>
Date: Sat, 5 Oct 2024 00:21:27 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.12.0
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Subject: Re: Same Table Name - 2 Owners
In-Reply-To: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------1sKMfrKJOGzedHhipvOJMKzc"
Archived-At: 
 <https://www.postgresql.org/message-id/caf17507-f447-2b52-1b88-5bcdcfd8621a%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------1sKMfrKJOGzedHhipvOJMKzc
Content-Type: multipart/mixed; boundary="------------7LjWxZ77yQHnQQP1hNIq9fUY";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <caf17507-f447-2b52-1b88-5bcdcfd8621a@jakobs.com>
Subject: Re: Same Table Name - 2 Owners
References: <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
In-Reply-To: <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>

--------------7LjWxZ77yQHnQQP1hNIq9fUY
Content-Type: multipart/alternative;
 boundary="------------NUqFFxqeWONqmggqDP5DrUdc"

--------------NUqFFxqeWONqmggqDP5DrUdc
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMDUuMTAuMjQgdW0gMDA6MDkgc2NocmllYiBTYW0gU3RlYXJuczoNCj4gSG93ZHksDQo+
DQo+IEluIE9yYWNsZSwgSSBoYXZlIGEgdGFibGUgbmFtZSB0aGF0IGlzIHRoZSBzYW1lIG5h
bWUgYmV0d2VlbiAyIA0KPiBkaWZmZXJlbnQgb3duZXJzIGJ1dCBjb21wbGV0ZWx5IGRpZmZl
cmVudCBEREw6DQo+DQo+DQo+IC9TUUw+IHNlbGVjdCBvd25lciwgb2JqZWN0X25hbWUsIG9i
amVjdF90eXBlIGZyb20gZGJhX29iamVjdHMgd2hlcmUgDQo+IG9iamVjdF9uYW1lID0gJ1NV
QlNDUklQVElPTlMnIGFuZCBvYmplY3RfdHlwZSA9ICdUQUJMRSc7DQo+DQo+IE9XTkVSIMKg
IMKgIMKgT0JKRUNUX05BTUUgwqAgwqAgwqAgwqAgwqBPQkpFQ1RfVFlQRQ0KPiAtLS0tLS0t
LS0tIC0tLS0tLS0tLS0tLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IElO
VEVSRkFDRSDCoFNVQlNDUklQVElPTlMgwqAgwqAgwqAgwqBUQUJMRQ0KPiBPUkFDTEUgwqAg
wqAgU1VCU0NSSVBUSU9OUyDCoCDCoCDCoCDCoFRBQkxFDQo+DQo+IFNRTD4vDQo+DQo+DQo+
IElzIGl0IHBvc3NpYmxlIHRvIGRvIHRoaXMgaW4gUG9zdGdyZXM/DQo+DQo+IC0tIA0KPg0K
PiAqU2FtdWVsIFN0ZWFybnMqDQo+IExlYWQgRGF0YWJhc2UgQWRtaW5pc3RyYXRvcg0KPiAq
YzoqwqA5NzEgNzYyIDY4NzkgfCAqbzoqwqA1MDMgNjcyIDUxMTUgfMKgREFULmNvbQ0KPg0K
PiBEQVQgDQo+IDxodHRwczovL3d3dy5kYXQuY29tLz91dG1fbWVkaXVtPWVtYWlsJnV0bV9z
b3VyY2U9REFUX2VtYWlsX3NpZ25hdHVyZV9saW5rPg0KSW4gT3JhY2xlLCBvd25lciBpcyBz
eW5vbm9tb3VzIHdpdGggYSBzY2hlbWEsIHRoZXkgYXJlIGNvdXBsZWQgMToxLiBTbyANCmRv
bid0IGJlIGZvb2xlZCwgdGhlIHR3byB0YWJsZXMgYXJlIGluIHR3byBkaWZmZXJlbnQgc2No
ZW1hcy4NCg0KSWYgeW91IHdhbnQgdG8gZG8gdGhpcyBpbiBQb3N0Z3JlU1FMLCBqdXN0IGNy
ZWF0ZSB0d28gc2NoZW1hcyBhbmQgcHV0IA0KdHdvIHRhYmxlcyB3aXRoIHRoZSBzYW1lIG5h
bWUgKGJ1dCBkaWZmZXJlbnQgcHJvcGVydGllcykgaW50byBlYWNoIG9mIA0KdGhlbSwgcmVz
cGVjdGl2ZWx5Lg0KDQpJbiBQb3N0Z3JlU1FMLCB1c2VycyAoYWN0dWFsbHkgbG9naW4gcm9s
ZXMpIGFuZCBzY2hlbWFzIGFyZW4ndCB0aWVkIHRvIA0KZWFjaCBvdGhlci4gWW91IGFyZSBm
cmVlIHRvIG5hbWUgdGhlbSBhcyB5b3Ugd2lzaC4NCg0KUmVnYXJkcywNCkhvbGdlcg0KDQoN
Cg==
--------------NUqFFxqeWONqmggqDP5DrUdc
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 05.10.24 um 00:09 schrieb Sam
      Stearns:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAN6TVj=3DTV0jpSN_zJ7uHZr+JQ=3DN8j8vRduxSNRdxepfDizncpw@mail.=
gmail.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Howdy,
        <div><br>
        </div>
        <div>In Oracle, I have a table name that is the same name
          between 2 different owners but completely different DDL:</div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div><i>SQL&gt; select owner, object_name, object_type from
            dba_objects where object_name =3D 'SUBSCRIPTIONS' and
            object_type =3D 'TABLE';<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=A0SUBSCRIPTIONS =C2=A0 =C2=A0 =C2=A0 =C2=A0TABL=
E<br>
            ORACLE =C2=A0 =C2=A0 SUBSCRIPTIONS =C2=A0 =C2=A0 =C2=A0 =C2=A0=
TABLE<br>
            <br>
            SQL&gt;</i></div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Is it possible to do this in Postgres?<br clear=3D"all">
          <div><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;Helvet=
ica
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</strong><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<stron=
g>o:</strong>=C2=A0503
                  672 5115=C2=A0<span style=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:medium"><a
href=3D"https://www.dat.com/?utm_medium=3Demail&amp;utm_source=3DDAT_emai=
l_signature_link"
                  target=3D"_blank" moz-do-not-send=3D"true"><img
src=3D"https://www.dat.com/wp-content/uploads/media/images/global/emails/=
signature2/dat_126.png"
                    alt=3D"DAT" moz-do-not-send=3D"true" width=3D"126"
                    height=3D"54"></a></div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <div class=3D"moz-signature">In Oracle, owner is synonomous with a
      schema, they are coupled 1:1. So don't be fooled, the two tables
      are in two different schemas.<br>
    </div>
    <div class=3D"moz-signature"><br>
    </div>
    <div class=3D"moz-signature">If you want to do this in PostgreSQL,
      just create two schemas and put two tables with the same name (but
      different properties) into each of them, respectively.</div>
    <div class=3D"moz-signature"><br>
    </div>
    <div class=3D"moz-signature">In PostgreSQL, users (actually login
      roles) and schemas aren't tied to each other. You are free to name
      them as you wish.</div>
    <div class=3D"moz-signature"><br>
    </div>
    <div class=3D"moz-signature">Regards,</div>
    <div class=3D"moz-signature">Holger<br>
    </div>
    <div class=3D"moz-signature"><br>
    </div>
    <div class=3D"moz-signature"><br>
    </div>
  </body>
</html>

--------------NUqFFxqeWONqmggqDP5DrUdc--

--------------7LjWxZ77yQHnQQP1hNIq9fUY--

--------------1sKMfrKJOGzedHhipvOJMKzc
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZwBqZwUDAAAAAAAKCRCKV5yTsxlhuue3
AJ4nfPuQfGTkN7ObGhJecRf7OMwb4wCeNj5BkZxpun7kZmThP4xJrSlJx+U=
=1+/N
-----END PGP SIGNATURE-----

--------------1sKMfrKJOGzedHhipvOJMKzc--