Re: Idle idea for a feature

Hi,

On 4/11/07, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> wrote:
>
> On 4/10/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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