Postgres version of all_ind_cols
От | Bart van Houdt |
---|---|
Тема | Postgres version of all_ind_cols |
Дата | |
Msg-id | CECE69D480C32F49891F27ED3E49C38C0494226C@nthvsexch02.interaccess.nl обсуждение исходный текст |
Ответ на | Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns (Mario Splivalo <mario.splivalo@megafon.hr>) |
Ответы |
Re: Postgres version of all_ind_cols
Re: Postgres version of all_ind_cols |
Список | pgsql-sql |
Hi all, This might be a stupid question, but I wasn't able to find any information on it, so here it goes: Oracle knows a view which contains information about indexed columns (all_ind_cols), is there something similar availablein Postgres? I want to be able to create an full overview of each column with the following information: - index name - table name the index is on - column name the index is on - column position in the index - sort order Any help would be much appreciated :) Regards, Bart van Houdt Syfact International B.V. Database developer
В списке pgsql-sql по дате отправления: