Get the name of a row's source table when querying the parent it inherits from

To identify the source table of a particular row, use the tableoid, like you found yourself already.
A cast to regclass retrieves the actual name, automatically schema-qualified where needed according to the current search_path.

SELECT *, tableoid::regclass::text AS table_name
FROM   master.tbl
WHERE  <some_condition>;

More:

  • Find out which schema based on table values
  • Select (retrieve) all records from multiple schemas using Postgres
  • How does the search_path influence identifier resolution and the "current schema"