Re: Named constraints - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Named constraints
Date
Msg-id 20020522234003.O76808-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Named constraints  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Named constraints
List pgsql-general
On Wed, 22 May 2002, Stephan Szabo wrote:

> On Wed, 22 May 2002, Francisco Reyes wrote:
> > GroupID         integer
> >         constraint fkgroup
> >         references Groups,
>
> Nope, that's right, it's just that the trigger
> names aren't the same as the constraint name.

Would be nice if the triggers used more meaninful names.

> If you violate the constraint it should use the
> given names, and when drop constraint works with
> fk constraints it'll use them as well.

Is there a way to list the constraints?
I did not see any '\d' parameter to list them.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Named constraints
Next
From: Stephan Szabo
Date:
Subject: Re: Named constraints