[lug] Q. on SQL Foreign Keys (PostgreSQL)

[stimits at comcast.net]

Hi,
 
I'm wondering if there is someone I might be able to ask a question off-list about SQL foreign keys (I'm using PostgreSQL, but this should apply to most SQL servers). Basically I'm trying to build an application which will read metadata tables and draw a graphical chart of complex relations (perhaps 1000 tables and almost all interrelated) and having a problem with foreign key descriptions. I've been trying to figure this out for quite some time, but can't wrap my brain around it. I want to know if my idea of how multi-column foreign keys work is correct, or if I need to approach this in a different way. Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20170823/88651385/attachment.html>