Re: [GENERAL] Foreign Key Storage

2000-08-21 Thread Stephan Szabo
You can get the information out of pg_trigger. Each references relationship will create three triggers in pg_trigger. It's not in a particularly friendly format though. There should be messages in the archives of either -general or -hackers about the details. (Or if you can't find it, I can g

[GENERAL] Foreign Key Storage

2000-08-21 Thread Jessica Engblom
I need to get access to all of the foreign keys in a database, but I am not sure where postgres stores them. Does anyone know it they are stored in a table or not, and if so which table? Thanks.