Re: finding UNIQUES in information_schema

Gerardo Herzig <gherzig@fmed.uba.ar> writes:
> Hi all. Im failing while trying to obtain some metainfo from
> information_schema. Acording to the docs, constraint_column_usage and
> key_column_usage views contains some information about constraints and
> indexes.

No, they contain information about constraints, period.  How did you
create those indexes?  If you made them via SQL-standard PRIMARY KEY or
UNIQUE constraint syntax, they should show in the information_schema.
Otherwise not.
        regards, tom lane