Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

drop sequence if exists one_for_all cascade;
drop table if exists base,t1,t2 cascade;
create sequence one_for_all as bigint;
create table base (id integer primary key default nextval('one_for_all'));
create table t1 (t1_data integer, primary key (id)) inherits (base);
create table t2 (t2_data integer, primary key (id)) inherits (base);
insert into t1 (t1_data) values (100);
1 rows affected

insert into t2 (t2_data) values (200);
1 rows affected

select b.*, b.tableoid::regclass
from base b;


id
tableoid


1
t1

2
t2


select *
from t1;


id
t1_data


1
100


select *
from t2;


id
t2_data


2
200