On Thu, 28 Feb 2002, Josh Berkus wrote:
> Damon,
>
> > Is it possible to determine which column(s), if any, are constrained
> > with PRIMARY KEY?
>
> From psql, use:
>
> \d table_name
>
> You will get a list of table characteristics, including any
> constraints.
>
> -Josh
>
Thanks...but is there a way to check PRIMARY KEY (and do other useful
things like get a listing of databases) from within an SQL query? I can't
embed psql '\' commands in my application.
Damon
---------
May the lights in The Land of Plenty
shine on the Truth some day L Cohen