Re: Newbie Constraint ?

Jeanna Geier wrote:
>  Hello List!
>
>  OK, so I'm new to SQL and Postgres and am working on taking over this DB
> work, and ran across a command that I'm not sure of and am wondering if you
> can help me with... Probably a basic SQL question, but thought more than one
> person on here would be able to point me in the right direction!!
>
>  In on of the tables in the DB, there is a constraint defined that I'm not
> familiar with:
>
>    CONSTRAINT "Relationship182" FOREIGN KEY (elementid)
>       REFERENCES element (elementid) MATCH SIMPLE
>       ON UPDATE CASCADE ON DELETE CASCADE
>
>
>  Not quite sure what the: CONSTRAINT "Relationship182" is exactly...  can
> anyone help me with this one?  Haven't seen this one yet...
>
That's the constraint name.
More detailed here:
http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html