public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sam Stearns <[email protected]>
To: Guillaume Lelarge <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: David G. Johnston <[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: Mon, 7 Oct 2024 08:36:30 -0700
Message-ID: <CAN6TVjn8oA93aykMi4HqupxOTqqPKmJefNdqFO0o1Urj=m-TzA@mail.gmail.com> (raw)
In-Reply-To: <CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com>
References: <CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com>
	<CAKFQuwZ-PZ-TCrTVN2z2VUAjDVOQjJD2sjh3SeXBeSVb0OWBWQ@mail.gmail.com>
	<[email protected]>
	<CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com>

Thank you all for the help!  We're testing this out now with some Oracle
imports into Postgres.

Sam

On Sat, Oct 5, 2024 at 12:07 AM Guillaume Lelarge <[email protected]>
wrote:

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


-- 

*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;

view thread (6+ messages)

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: <CAN6TVjn8oA93aykMi4HqupxOTqqPKmJefNdqFO0o1Urj=m-TzA@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