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