Identify an inherited table

Поиск
Список
Период
Сортировка
От Bo Lorentsen
Тема Identify an inherited table
Дата
Msg-id 3B85F804.AF5997D5@netgroup.dk
обсуждение исходный текст
Ответы Re: Identify an inherited table
Список 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 по дате отправления: