Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> As the subject says, I would like to access a temporary table of another
> session, while being the postgres superuser. Is this possible somehow ?
No. It is not a matter of permissions, it is a matter of physically not
having access to the data: buffers for temp tables are private to
individual backends, not shared, for performance reasons.
regards, tom lane