"Eric Johnson" <ericlj63@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
