finding UNIQUES in information_schema
От | Gerardo Herzig |
---|---|
Тема | finding UNIQUES in information_schema |
Дата | |
Msg-id | 49E787FC.8020909@fmed.uba.ar обсуждение исходный текст |
Ответы |
Re: finding UNIQUES in information_schema
|
Список | pgsql-sql |
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 | Modifiers -------------+------------------------+--------------------------------formu | integer |alucod | integer | default 0codcarr | character varying(3) | default ''::character varyinganifm | charactervarying(2) | default 20comentarios | text | default ''::text Indexes: "almatnov_alucod_codcarr_idx" UNIQUE, btree (alucod, codcarr) "almatnov_codcarr_alucod" UNIQUE, btree (alucod,codcarr) And now: ematerias=# SELECT * from information_schema.constraint_table_usage where table_name='almatnov';table_catalog | table_schema | table_name | constraint_catalog | constraint_schema | constraint_name ---------------+--------------+------------+--------------------+-------------------+----------------- (0 rows) ematerias=# SELECT * from information_schema.key_column_usage where table_name='almatnov';constraint_catalog | constraint_schema | constraint_name | table_catalog | table_schema | table_name | column_name | ordinal_position | position_in_unique_constraint --------------------+-------------------+-----------------+---------------+--------------+------------+-------------+------------------+------------------------------- (0 rows) 1) Im a doing anything wrong? 2) It is safe to extract metainfo from pg_catalog? Thanks! Gerardo
В списке pgsql-sql по дате отправления: