[GENERAL] Inherits tables and current CVS

[Teodor Sigaev]

How can I know tables is inherited or no?

# 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