How to find non-unique indexes in system tables
I can find all the check constraints, primary keys and foreign keys in
the information schema, but I cannot find the non-unique indexes. Is
there anyplace to get that information (name, columns, etc)?
Sorry if this is an FAQ. I couldn't find it with Google.
--
Eric Johnson
"Where your pleasure is, there is your treasure: where your treasure,
there your heart; where your heart, there your happiness."
Saint Augustine
"Eric Johnson" <ericlj63@gmail.com> writes:
I can find all the check constraints, primary keys and foreign keys in
the information schema, but I cannot find the non-unique indexes. Is
there anyplace to get that information (name, columns, etc)?
Not from the information_schema, because "index" is actually not a
concept in the SQL standard. Unique constraints are in the spec,
so you can see those via information_schema, but for other sorts
of indexes you have to look directly at the PG catalogs.
regards, tom lane