Re: finding UNIQUES in information_schema - Mailing list pgsql-sql

From Tom Lane
Subject Re: finding UNIQUES in information_schema
Date
Msg-id 28152.1239909139@sss.pgh.pa.us
Whole thread Raw
In response to finding UNIQUES in information_schema  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: finding UNIQUES in information_schema
List pgsql-sql
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


pgsql-sql by date:

Previous
From: DM
Date:
Subject: Re: how to set the value to the column
Next
From: Gerardo Herzig
Date:
Subject: Re: finding UNIQUES in information_schema