Re: Same Table Name - 2 Owners
| От | Guillaume Lelarge |
|---|---|
| Тема | Re: Same Table Name - 2 Owners |
| Дата | |
| Msg-id | CAECtzeXkpJrDxRRKHdS=mz5Sp2PoNqO8AOjmNmb1PF5Y=hj0uA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Same Table Name - 2 Owners (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Same Table Name - 2 Owners
|
| Список | 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
Great article on this topic: https://stormatics.tech/blogs/transitioning-from-oracle-to-postgresql-understanding-the-concept-of-schema
Regards.
--
Guillaume.
В списке pgsql-admin по дате отправления: