Access a temporary table of another session - is it possible ?
Hi all,
As the subject says, I would like to access a temporary table of another
session, while being the postgres superuser. Is this possible somehow ?
The problem is that I lost the terminal of the other session and I
really would like to see the results (even if partial) of some long
running operations... pg_stats_activity still shows the query running
against that table, so I still have a chance that the table actually
exists.
Thanks,
Csaba.
Csaba Nagy <nagy@ecircle-ag.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