How to retrieve functional index column names - Mailing list pgsql-hackers

From glogy@centrum.cz (Jakub)
Subject How to retrieve functional index column names
Date
Msg-id c7ed2227.0401052332.3512fbd0@posting.google.com
Whole thread Raw
Responses Re: How to retrieve functional index column names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,
I need to retrieve the name of the function and the index column names
of the functional index. The system information about the
index(function and its args) is stored in the system catalog column
pg_index.indexprs. Do I have to parse pg_index.indexprs text or
pg_get_indexdef(pg_index.indexrelid) result? Am I wrong? Is there
another way to retrieve the column names? Could anybody help me
please.

Regards Jakub


pgsql-hackers by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Re: psql \d option list overloaded
Next
From: Michael Gill
Date:
Subject: Re: Restrict users from describing table