glogy(at)centrum(dot)cz (Jakub) writes:
> 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.
As of 7.4, this is a requirement badly in need of reconsideration.
What makes you think there is any function name involved? Consider
something like
create index i on t ((col + 2));
Getting the column names is still a sensible operation though. I'd
suggest looking in pg_depend to see which columns of the table the
index depends on.
regards, tom lane