Identify an inherited table

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Identify an inherited table
Date: 2001-08-24 06:45:24
Message-ID: 3B85F804.AF5997D5@netgroup.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luke Tudor 2001-08-24 08:56:38 Users which aren't users?
Previous Message Bo Lorentsen 2001-08-24 06:38:43 Re: integrity and inherit