session 1:
create temp table ttt ( a int );
insert into ttt values(3); -- query_id is XXX from pg_stat_activity
session 2:
create temp table ttt ( a int );
insert into ttt values(3);
-- query_id is YYY from pg_stat_activity
I know temp table has different oid, so query_id is different, is there a way to use table name for temp table
instead of oid?
|