Re: [GENERAL] How do I list foreign key info/relation

2000-11-13 Thread Stephan Szabo
Unfortunately I don't think there's a good way to do it in SQL itself. You might be able to do something in one of the procedural languages. When i did the support for the older pg_dump (which may look nothing like the current one), all I did was enhance the code that was already there to handl

Re: [GENERAL] How do I list foreign key info/relation

2000-11-13 Thread Jason Davies
Hi, Thanks for that. My problem now is it would be nice to have a way to get this in one SQL query. I can't find a way to split up the pg_trigger.tgargs column up into components. The data I need is separated by "\000", but the column type is bytea. How do I split it up? I've tried using instr an