extracting constraints from schema

Поиск
Список
Период
Сортировка
От Agnieszka Rutkowska
Тема extracting constraints from schema
Дата
Msg-id Pine.LNX.4.44.0301291520380.16179-100000@piano07.orchestra.cse.unsw.EDU.AU
обсуждение исходный текст
Список pgsql-sql
Hi,

I was just wondering whether you happen to know how to extract what the
table and column constraints are using jdbc?
The API provides methods for extracting meta data on the table names,
column names, primary and foreigh keys as well as column types and sizes.
What about extracting constraints such as

salary    real    CHECK (salary >= 10000)

?
It is possible to obtain the column name 'salary' as well as its types as
being 'real' but how about the CHECK condition?? Can it be done using
jdbc?

Thanks for your time and help
Agnes



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

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: Controlling access to Sequences
Следующее
От: Sondaar Roelof
Дата:
Сообщение: Re: Creating tables from within functions