Hi,
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!

Tyson

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

TWENGER2@wi.rr.com writes:
> 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!

pg_depend might help, although I think it'd be a multi-step link.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On 29-Jan-07, at 1:06 PM, TWENGER2@wi.rr.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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster