| From: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | Peter Garza <peter(dot)garza(at)dat(dot)com>, Henry Ashu <henry(dot)ashu(at)dat(dot)com> |
| Subject: | Same Table Name - 2 Owners |
| Date: | 2024-10-04 22:09:59 |
| Message-ID: | CAN6TVj=TV0jpSN_zJ7uHZr+JQ=N8j8vRduxSNRdxepfDizncpw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 TABLEORACLE
SUBSCRIPTIONS TABLESQL>*
Is it possible to do this in Postgres?
--
*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-10-04 22:17:03 | Re: Same Table Name - 2 Owners |
| Previous Message | Casey | 2024-10-03 21:48:20 | Re: Can't log in after password change |