public inbox for [email protected]
help / color / mirror / Atom feedFrom: Guillaume Lelarge <[email protected]>
To: Tom Lane <[email protected]>
Cc: 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: Sat, 5 Oct 2024 09:07:05 +0200
Message-ID: <CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
<CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
<[email protected]>
Hello,
Le sam. 5 oct. 2024 à 00:22, Tom Lane <[email protected]> a écrit :
> "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.
>
>
+1
Great article on this topic:
https://stormatics.tech/blogs/transitioning-from-oracle-to-postgresql-understanding-the-concept-of-s...
Regards.
--
Guillaume.
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], [email protected]
Subject: Re: Same Table Name - 2 Owners
In-Reply-To: <CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com>
* 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