# create table parent (
id int primary key,
value text
);# create table child (
cval text,
primary key (id)
) INHERITS (parent);# \d child
Table "public.child"
Column | Type | Modifiers
--------+---------+-----------
id | integer | not null
value | text |
cval | text |
Indexes:
"child_pkey" PRIMARY KEY btree (id)\d doesn show any info about inheritance....
-- Teodor Sigaev E-mail: [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
