On May 24, 2012, at 2:01 PM, George Woodring wrote:
Is it possible to identify which inherited table data came from in a query? We have a table that has 3 inherited tables attached to it. I am looking for a way to identify the source of the data.
My only thought would be to add a column to the tables that identify the table. I was just checking if there was a way to do it without the column.
There is a special column on every row of your table called "tableoid" which identifies the original relation the row belongs to. This identifier can be matched up to the name of the relation in the pg_class table.
Jonathan