Scott Cain <cain@cshl.edu> writes:
> What I haven't figure out is this: how does one determine what the
> declarative statement is for a functional index that is obtained from
> pg_index.indexprs? What I would like to be able to do is be able to
> recreate the SQL that defined that index. Is that represented somewhere
> in another system table?
Use pg_get_indexdef().
regards, tom lane