Re: Same Table Name - 2 Owners - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Same Table Name - 2 Owners
Date
Msg-id CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com
Whole thread Raw
In response to Re: Same Table Name - 2 Owners  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Same Table Name - 2 Owners
List pgsql-admin
Hello,

Le sam. 5 oct. 2024 à 00:22, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
"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.


+1


Regards.


--
Guillaume.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Same Table Name - 2 Owners
Next
From: pramod kg
Date:
Subject: Ensure 'User' Runtime Parameters are Configured