On 7/9/06 9:40 AM, "Verena Ruff" <lists(at)triosolutions(dot)at> wrote:
>
> Hello,
>
> I have some inherited tables, which all share the same primary key, like
>
> table1 with PK id
> table2 inherits table1 with PK id
> table3 inherits table1 with PK id
>
> where id is a serial.
>
> If I have an id, is there an easy way to find out in which of these
> tables this record is created (was it INSERT INTO table1 or INSERT INTO
> table2 or INSERT INTO table3)?
There is an example in the docs:
http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html
Sean