Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id C4D6B6322FF
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  5 Aug 2010 21:19:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 51524-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  6 Aug 2010 00:19:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f174.google.com (mail-gx0-f174.google.com
	[209.85.161.174])
	by mail.postgresql.org (Postfix) with ESMTP id E30F5632BCF
	for <pgsql-admin@postgresql.org>; Thu,  5 Aug 2010 21:19:07 -0300 (ADT)
Received: by gxk23 with SMTP id 23so2691187gxk.19
	for <pgsql-admin@postgresql.org>; Thu, 05 Aug 2010 17:19:06 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:subject:mime-version
	:content-type:from:in-reply-to:date:cc:content-transfer-encoding
	:message-id:references:to:x-mailer;
	bh=atXwC8jonZNqHJXr4u9pvvbQb105g3JzwFPmu6wI3Qo=;
	b=ZrGFi0+IG/W+MfHZAQN9UXgBt5e6S56A6HgbNmMzkI9aD+gbR/c9BxTIfcNkYilUoR
	Ymoa0hC34wOGOxM2mRJvfb7Kb3+GinSFU+ZHBKYabGD9lOfyM4N2GguBnNXBmzSWSvhz
	/JBJKbpqNDrDH/FRR8szHoIxGvSidpDCWvZsA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=Rbz7GO5iUv0EXng7oLAviY/Ia3xtafP97twoaipCOJ1j0V1wgvLv4rcjKWFSoQbIRK
	XJ9qtGvZ8mQo/4W7CTUNttxv+OYCugxpYA6g/zNQE6N4axqWalPZ/BfBsctc3wYNajmA
	MqEDoZEzIYV2gr5f9cQOxEZGxpk18IGR40Tlg=
Received: by 10.151.93.19 with SMTP id v19mr12639131ybl.381.1281053946406;
	Thu, 05 Aug 2010 17:19:06 -0700 (PDT)
Received: from [192.168.15.2] (c-24-1-168-95.hsd1.in.comcast.net
 [24.1.168.95])
	by mx.google.com with ESMTPS id h11sm2757019ybk.17.2010.08.05.17.19.04
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Thu, 05 Aug 2010 17:19:05 -0700 (PDT)
Subject: Re: Partitioned table system info
Mime-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <201008051711.07394.cs_dba@consistentstate.com>
Date: Thu, 5 Aug 2010 20:19:02 -0400
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <5A00958E-18FD-4C6A-9020-F966DA9AAF33@gmail.com>
References: <201008051711.07394.cs_dba@consistentstate.com>
To: Kevin Kempter <cs_dba@consistentstate.com>
X-Mailer: Apple Mail (2.1081)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201008/38
X-Sequence-Number: 35287

Following query would help you:

 select inhparent::pg_catalog.regclass, inhrelid::pg_catalog.regclass =
from pg_inherits;

Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
On Aug 5, 2010, at 7:11 PM, Kevin Kempter wrote:

> Hi All;
>=20
> can anyone point me to a system catalog query that will show me the =
base table=20
> name, and all partition table names for any table that has children=20
> (inheritance) ?
>=20
>=20
> Thanks in advance
>=20
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin