Re: [SQL] finding UNIQUES in information_schema

2009-04-16 Thread Tom Lane
Gerardo Herzig 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 don

Re: [SQL] finding UNIQUES in information_schema

2009-04-16 Thread Gerardo Herzig
Tom Lane wrote: > Gerardo Herzig 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

Re: [SQL] finding UNIQUES in information_schema

2009-04-16 Thread Tom Lane
Gerardo Herzig 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.

[SQL] finding UNIQUES in information_schema

2009-04-16 Thread Gerardo Herzig
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. See: Table "public.almatnov" Column| Type