On Wed, Feb 16, 2011 at 2:42 AM, Sivannarayanreddy <
sivannarayanre...@subexworld.com> wrote:
> Hello,
> I am checking the compatibility of my product with Postgres database and i
> stucked in forming the below oracle equivalent queries in Postgres database,
> Could some one help me pleaseee
>
>
Thomas Kellerer 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
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 v
2011/2/16 Thomas Kellerer :
> Pavel Stehule, 16.02.2011 11:50:
>>
>> Try to use a standardized information_schema instead - these views are
>> same on PostgreSQL and Oracle.
>
> Unfortunately they are not the same: Oracle does not support
> INFORMATION_SCHEMA
>
sorry, I expected so all mature data
hello
list of tables
http://www.postgresql.org/docs/current/static/infoschema-tables.html
information about column
http://www.postgresql.org/docs/current/static/infoschema-columns.html
information about indexes - it's not part of ANSI/SQL so you have to look to
pg_index or pg_indexes.
Regards
P
Pavel Stehule, 16.02.2011 11:50:
Try to use a standardized information_schema instead - these views are same on
PostgreSQL and Oracle.
Unfortunately they are not the same: Oracle does not support INFORMATION_SCHEMA
Regards
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
Hello
PostgreSQL uses a different system tables than Oracle. Try to use a
standardized information_schema instead - these views are same on PostgreSQL
and Oracle.
http://www.postgresql.org/docs/current/static/information-schema.html
Regards
Pavel Stehule
2011/2/16 Sivannarayanreddy
> Hel
Title:
Hello,
I am checking the compatibility of my product with Postgres database
and i stucked in forming the below oracle equivalent queries in
Postgres database, Could some one help me pleaseee
1) Trying to get index and corresponding columns information of a
