Postgres Pro
Downloads
Home   >   mailing lists

Re: Inherited table identification possible - Mailing list pgsql-sql

From Stephen Belcher
Subject Re: Inherited table identification possible
Date
Msg-id CADJqQNmmH+F+jOO83W9vxBLov_yw5Ry+xj4Ag2daPN7WDEWnMA@mail.gmail.com
Whole thread Raw
In response to Inherited table identification possible  (George Woodring <george.woodring@iglass.net>)
Responses Re: Inherited table identification possible  (George Woodring <george.woodring@iglass.net>)
List pgsql-sql
Tree view
Yes, the system column "tableoid" identifies the actual table in which the row is stored. If you cast this to "regclass" you'll get the name of the table that the row is stored in:

SELECT tableoid::regclass FROM base_table;

There's more documentation on this available at http://www.postgresql.org/docs/9.1/static/ddl-inherit.html (for version 9.1, at any rate: season to taste with your version of PG)

Hope this helps,
--Stephen


On Thu, May 24, 2012 at 2:01 PM, George Woodring <george.woodring@iglass.net> 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.

Thanks,
George



--
iGLASS Networks
www.iglass.net

pgsql-sql by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: Inherited table identification possible
Next
From: "Raj Mathur (राज माथुर)"
Date:
Subject: Re: Flatten table using timestamp and source