David Rowley <dgrowleyml@xxxxxxxxx> writes: > On Tue, 10 Mar 2020 at 02:16, Sterpu Victor <victor@xxxxxxxx> wrote: >> How can I retrieve this detail? > Those details are in the indexprs column. There's an item there for > each 0 valued indkey. It's not going to be particularly easy for you > to parse that from SQL. Internally in PostgreSQL, we have functions > that could give you that information easily, but to access those from > SQL you'd need to write something in C. You could use pg_get_indexdef(). I agree that parsing indexprs from SQL is not to be recommended --- aside from being very complex, it would break on a regular basis, because we change those structs often. regards, tom lane
