Received: from avocet.prod.itd.earthlink.net (avocet.mail.pas.earthlink.net [207.217.120.50]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBH16Cm47458 for ; Sun, 16 Dec 2001 20:06:12 -0500 (EST) (envelope-from metaperl@mac.com) Received: from pool0847.cvx36-bradley.dialup.earthlink.net ([216.244.21.82] helo=localhost) by avocet.prod.itd.earthlink.net with esmtp (Exim 3.33 #1) id 16FmEN-0006A6-00 for pgsql-sql@postgresql.org; Sun, 16 Dec 2001 17:06:11 -0800 Date: Sun, 16 Dec 2001 16:00:53 -0800 Subject: why doesn't \d table_name show the table inheritance graph? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Mime-Version: 1.0 (Apple Message framework v475) From: Terrence Brannon To: pgsql-sql@postgresql.org In-Reply-To: <20011211163822.O70071-100000@teak.adhesivemedia.com> Message-Id: <2332B94E-F281-11D5-92F7-003065C2A10C@mac.com> X-Mailer: Apple Mail (2.475) Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fBH19Sn47619 X-Archive-Number: 200112/164 X-Sequence-Number: 5987 The Momjian books shows this:  test=> CREATE TABLE parent_test (col1 INTEGER);         CREATE         test=> CREATE TABLE child_test (col2 INTEGER) INHERITS  (parent_test);         CREATE         test=> \d parent_test                  Table "parent_test"          Attribute |  Type   | Modifier          -----------+---------+----------          col1      | integer |                    test=> \d child_test                  Table "child_test"          Attribute |  Type   | Modifier          -----------+---------+----------          col1      | integer |           col2      | integer |    but I think it would be very important, to know inheritance as to know indexes.