From: | Terrence Brannon <metaperl(at)mac(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | why doesn't \d table_name show the table inheritance graph? |
Date: | 2001-12-17 00:00:53 |
Message-ID: | 2332B94E-F281-11D5-92F7-003065C2A10C@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-17 01:33:30 | Re: why doesn't \d table_name show the table inheritance graph? |
Previous Message | Terrence Brannon | 2001-12-16 23:54:16 | temp tables versus the global sql area |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-17 01:33:30 | Re: why doesn't \d table_name show the table inheritance graph? |
Previous Message | Terrence Brannon | 2001-12-16 23:54:16 | temp tables versus the global sql area |