Gerardo Herzig <gher...@fmed.uba.ar> writes: > Tom Lane wrote: >> 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.
> Well, i just dont get it. No, apparently not. The term "constraint" in this context has a very specific meaning; it's talking about the CONSTRAINT syntax in CREATE TABLE or ALTER TABLE. This is per SQL specification. Indexes are an implementation detail that the standard doesn't concern itself with; therefore anything you do with CREATE INDEX is outside the standard and is not reflected in the standard-defined information_schema. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql