Re: Same Table Name - 2 Owners

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes:
> On Friday, October 4, 2024, Sam Stearns <sam.stearns@xxxxxxx> 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.

			regards, tom lane





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux