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

From Sam Stearns
Subject Same Table Name - 2 Owners
Date
Msg-id CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com
Whole thread Raw
Responses Re: Same Table Name - 2 Owners
List pgsql-admin
Howdy,

In Oracle, I have a table name that is the same name between 2 different owners but completely different DDL:


SQL> select owner, object_name, object_type from dba_objects where object_name = 'SUBSCRIPTIONS' and object_type = 'TABLE';

OWNER      OBJECT_NAME          OBJECT_TYPE
---------- -------------------- -----------------------
INTERFACE  SUBSCRIPTIONS        TABLE
ORACLE     SUBSCRIPTIONS        TABLE

SQL>


Is it possible to do this in Postgres?

--

Samuel Stearns
Lead Database Administrator
c: 971 762 6879 | o: 503 672 5115 | DAT.com

DAT

pgsql-admin by date:

Previous
From: Casey
Date:
Subject: Re: Can't log in after password change
Next
From: "David G. Johnston"
Date:
Subject: Re: Same Table Name - 2 Owners