Re: [SQL] SQL to retrieve foreign keys

2000-10-11 Thread Stephan Szabo
Actually, right now it isn't trivial with the implementation. You need to decode things out of the arguments to triggers which are in a bytea and there aren't alot of reasonable sql level stuff to decode it. If you don't mind doing some of the work on the front end, you should be able do it. If

[SQL] SQL to retrieve foreign keys

2000-10-11 Thread Colleen Williams
Hi, I would like to write some SQL to extend the phpPgAdmin tool where it only displays primary keys related to a table. I have looked at the programmers doco and searched the discussions on foreign keys but was not able to decipher how to write the SQL. It is probably really trivial for someo