In particular, this simple query shows the constraints for a given table that are foreign key constraints and which primary key constraints they depend on. displayForeignKeyConstraints.sql ...

Can you do a foreign key within a single table, though? I've only ever seen foreign key constraints tying a field in one table to a field in another table.

I have a foreign key constraint that I created to reference the primary key of another table:constraint geneassay_fk foreign key (geneassay) references ...