Re: how to determine array size
| От | Forest Wilkinson | 
|---|---|
| Тема | Re: how to determine array size | 
| Дата | |
| Msg-id | 7c5cev0486tkbu5rdne84cki9fvim3l60n@4ax.com обсуждение исходный текст | 
| Ответ на | Re: how to determine array size (Rod Taylor <rbt@rbt.ca>) | 
| Ответы | Re: how to determine array size | 
| Список | pgsql-sql | 
>> I need to enumerate the constraints on any given column in a table, so >> I'm examining pg_constraint to get the relevant information. The >> conkey array contains a list of constrained columns, and although I am >> able to check conkey[1] for constraints on a single column, I would >> like to properly handle multi-column constraints. > >You may have an easier time dealing with pg_get_constraintdef() than >trying to get the info from the source. Is pg_get_constraintdef() documented somewhere? I'd like to know it's arguments, return format, and whether it will be supported in future postgres releases. From what I see in pg_dump.c, it appears to accept an oid from the pg_constraint table, and only work with foreign key constraints. True? That might be useful in some special-case code, but I really want a method that will work with all types of constraint. (The idea here is to enumerate all constraints on a table, along with their names, types, and constrained columns.)
В списке pgsql-sql по дате отправления: