Hi,

On 4/11/07, Guillaume Smet <[EMAIL PROTECTED]> wrote:


On 4/10/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> ISTM it'd be a good idea if it did, as "are there any incoming
> foreign keys" seems to be a question we constantly ask when solving
> update-performance problems, and there isn't any easy way to check for
> such.

On similar lines, maybe \d can also show the list of inheritors when
invoked on a parent.
e.g:
postgres=# \d parent
   Table "public.parent"
Column |  Type   | Modifiers
--------+---------+-----------
a      | integer |
Indexes:
   "parent_a_key" UNIQUE, btree (a)
Inherited by: child

Regards,
Nikhils
--
EnterpriseDB               http://www.enterprisedb.com

Reply via email to