how to determine table? - Mailing list pgsql-sql

From Don Yury
Subject how to determine table?
Date
Msg-id 37969C56.ADFC172B@vpcit.ru
Whole thread Raw
List pgsql-sql
Hi All.

Suppose I do select from class with all subclasses, for example

SELECT id, name FROM TAB*

and I get something like

id | name
---------
1  | n1
2  | n2
3  | n3
...

Then I want to know about certain record name of table where this record
is stored, for example I want to know in which table record (2, n2). How
I can do this?
I guess I can add field 'tablename' to every subclass of tab class and
fill it with certain table name in trigger, but perhaps exists more easy
way?

Sincerely yours, Yury.
don.web-page.net, ICQ 11831432


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins
Next
From: Chris Bitmead
Date:
Subject: Re: [SQL] how to determine table?