public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Sam Stearns <[email protected]>
Cc: Pgsql-admin <[email protected]>
Cc: Peter Garza <[email protected]>
Cc: Henry Ashu <[email protected]>
Subject: Re: Same Table Name - 2 Owners
Date: Fri, 04 Oct 2024 18:22:28 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
References: <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
	<CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>

"David G. Johnston" <[email protected]> writes:
> On Friday, October 4, 2024, Sam Stearns <[email protected]> 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

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Same Table Name - 2 Owners
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox