Identify an inherited table - Mailing list pgsql-novice

From Bo Lorentsen
Subject Identify an inherited table
Date
Msg-id 3B85F804.AF5997D5@netgroup.dk
Whole thread Raw
Responses Re: Identify an inherited table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi ...

When using a database with inherited tables it somtimes would be nice if
the row you are looking at is a base, a child or even a grandchild type.
Like this :

    SELECT id, type() FROM base;

id  | unknown
----------
1   | base
2   | child

Or something like this.

Is this possible or does this include alot funny SQL to gain ?

/BL


pgsql-novice by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: integrity and inherit
Next
From: Luke Tudor
Date:
Subject: Users which aren't users?