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