Re: how to determine array size

On Mon, 2003-06-09 at 16:23, Forest Wilkinson wrote:
> 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.

The above function outputs the necessary SQL to rebuild the constraint,
and is used by pg_dump.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc