how to recover a domain types and constraints?

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема how to recover a domain types and constraints?
Дата
Msg-id 20110612070512.6daddeea@anubis.defcon1
обсуждение исходный текст
Ответы Re: how to recover a domain types and constraints? [SOLVED]  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Список pgsql-novice
Hi list,

I intend to recover domains type (I/O) and their constraints from my DB in
order to simplify the program that access the DB (so, using types & constraints
to auto-implement them into my program.)

I already found a query to recover domain types from a function:
SELECT function_args('testaddctr', 'public');
         function_args
-------------------------------
 (0,o,"RETURN VALUE",smallint)
 (1,i,,dn_ctr)
 (2,i,,dn_ctr)
(3 rows)

But how could I know that:
dn_ctr =            smallint
dn_ctr constraints: NOT NULL & CHECK(VALUE > -1)
?

JY
--
BOFH excuse #172:
pseudo-user on a pseudo-terminal

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_ctl -o options
Следующее
От: "Jean-Yves F. Barbier"
Дата:
Сообщение: images in one or more tables?