Postgres Pro
Downloads
Home   >   mailing lists

Re: RI Constraint display - Mailing list pgsql-general

From Tom Lane
Subject Re: RI Constraint display
Date
Msg-id 13592.1040939100@sss.pgh.pa.us
Whole thread Raw
In response to RI Constraint display  (elein <elein@sbcglobal.net>)
Responses Re: RI Constraint display  (elein <elein@sbcglobal.net>)
List pgsql-general
Tree view 
elein <elein@sbcglobal.net> writes:
> Referential integrity constraints are displayed as $n.

If you didn't assign a name to the constraint, that's what the generated
names look like.  Try "CONSTRAINT foo FOREIGN KEY ...".

            regards, tom lane

pgsql-general by date:

Previous
From: elein
Date:
Subject: RI Constraint display
Next
From: jco@cornelius-olsen.dk
Date:
Subject: Postgres array cast