Hi,
On 4/11/07, Guillaume Smet <guillaume.smet@gmail.com> wrote: On 4/10/07, Tom Lane <tgl@sss.pgh.pa.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