pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Terrence Brannon <metaperl@mac.com>
To: pgsql-sql@postgresql.org
Subject: why doesn't \d table_name show the table inheritance graph?
Date: Sun, 16 Dec 2001 16:00:53 -0800
Message-ID: <2332B94E-F281-11D5-92F7-003065C2A10C@mac.com> (raw)
In-Reply-To: <20011211163822.O70071-100000@teak.adhesivemedia.com>

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.




view thread (2+ messages)  latest in thread

Message-ID: <2332B94E-F281-11D5-92F7-003065C2A10C@mac.com>
Permalink:  ../2332B94E-F281-11D5-92F7-003065C2A10C@mac.com/
Also on:    postgresql.org/message-id/2332B94E-F281-11D5-92F7-003065C2A10C@mac.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: metaperl@mac.com
  Subject: Re: why doesn't \d table_name show the table inheritance graph?
  In-Reply-To: <2332B94E-F281-11D5-92F7-003065C2A10C@mac.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox