Re: dependency ?

[Brian Wipf <brian(at)clickspace(dot)com>]

On 29-Jan-07, at 1:06 PM, TWENGER2(at)wi(dot)rr(dot)com wrote:
>   I was wondering if there is any way to use psql to list tables that
> are dependent to a specific table.  Instead of going through every  
> table
> in my database and looking for foreign keys, can I somehow get an  
> entire
> list of these dependent tables?  Any help would be much  
> appreciated, thanks!

You could do this easily enough in the shell. For example, If I  
wanted to find all tables that reference foo_table:

psql -U postgres database_name -c '\d *' | egrep "(Table |REFERENCES  
foo_table)" | grep -B1 'REFERENCES foo_table' | grep 'Table ' | cut - 
d '"' -f 2

should do the trick.

Brian Wipf