Re: finding UNIQUES in information_schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: finding UNIQUES in information_schema
Date: 2009-04-16 19:12:19
Message-ID: 28152.1239909139@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gerardo Herzig 2009-04-16 19:33:16 finding UNIQUES in information_schema
Previous Message Andreas Kretschmer 2009-04-16 19:11:17 Re: how to set the value to the column