Re: How do I list foreign key info/relation

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 handle constraint triggers.

You will probably have to break it up on the client side.  If I get a
chance to do computer stuff other than job related stuff I'm probably
going to write something that will return a constraint string for fk
constraints that look like the original statement (plus or minus a
little).

Stephan Szabo
sszabo@bigpanda.com

On Mon, 13 Nov 2000, Jason Davies wrote:

> 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 and substr, but I can't
> get them to work.