inherited tables

From: "Verena Ruff" <lists(at)triosolutions(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Subject: inherited tables
Date: 2006-07-09 13:40:46
Message-ID: 20314.86.59.55.246.1152452446.squirrel@v2830.vanager.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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)?
Hope you understood what I intented to say.

Regards,
Verena

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-07-10 11:01:25 Re: inherited tables
Previous Message Laurent FRANCOIS 2006-07-09 11:17:27 Re: Help!