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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Ordering a name list and ignoring whitespace
Следующее
От: DM
Дата:
Сообщение: how to set the value to the column