Re: dependency ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: TWENGER2(at)wi(dot)rr(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dependency ?
Date: 2007-01-29 20:37:14
Message-ID: 19364.1170103034@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

TWENGER2(at)wi(dot)rr(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Thibaudeau 2007-01-29 20:46:34 Fwd: convert(USING utf8_to_iso_8859_15) on Windows
Previous Message Shoaib Mir 2007-01-29 20:19:55 Re: Locking question?