Re: Same Table Name - 2 Owners

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 <guillaume(at)lelarge(dot)info>
wrote:

> Hello,
>
> Le sam. 5 oct. 2024 à 00:22, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :
>
>> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
>> > On Friday, October 4, 2024, Sam Stearns <sam(dot)stearns(at)dat(dot)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.
>>
>>
> +1
>
> Great article on this topic:
> https://stormatics.tech/blogs/transitioning-from-oracle-to-postgresql-understanding-the-concept-of-schema
>
> 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>