| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Oracle Equivalent queries in Postgres |
| Date: | 2011-02-16 15:11:23 |
| Message-ID: | 24670.1297869083@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> Pavel Stehule, 16.02.2011 12:20:
>>> Unfortunately they are not the same: Oracle does not support
>>> INFORMATION_SCHEMA
>> sorry, I expected so all mature databases support it.
> Yes, this is really hard to understand.
> I would assume creating the INFORMATION_SCHEMA views based on the existing Oracle views is just a matter of maybe 3-4 days of days work. So it is really not understandable that Oracle does not support this.
> But then they probably don't care - after all it's Oracle.
No, from their point of view it would be actively damaging: providing
standardized views would reduce customer lock-in, by making applications
more portable to other DBMSes. The pain the OP is feeling is a
marketing advantage, so far as Oracle is concerned.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | arthur_info | 2011-02-16 16:16:16 | Retrieve the column values of a record without knowing the names |
| Previous Message | Pavel Stehule | 2011-02-16 12:49:47 | Re: Function compile error |