Same Table Name - 2 Owners

Поиск
Список
Период
Сортировка
От Sam Stearns
Тема Same Table Name - 2 Owners
Дата
Msg-id CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Same Table Name - 2 Owners
Список 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 по дате отправления: