Same Table Name - 2 Owners

[Sam Stearns <sam.stearns@xxxxxxx>]

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