From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: 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>
Subject: Re: Same Table Name - 2 Owners
In-reply-to: 
 <CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
References: 
 <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
 <CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Fri, 04 Oct 2024 15:17:03 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <717425.1728080548.1@sss.pgh.pa.us>
Date: Fri, 04 Oct 2024 18:22:28 -0400
Message-ID: <717426.1728080548@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/717426.1728080548%40sss.pgh.pa.us>
Precedence: bulk

"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.

			regards, tom lane