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