Is there a way to access temporary tables of other sessions in postgres?
22
votes
3
answers
31518
views
I'm working with a Windows application that uses a (local) postgres Database and stores some information in a temporary table. I'd like to have a look at the temporary table, but pgadmin and dbVis tell me:
ERROR: cannot access temporary tables of other sessions
when trying to query the data. I tried changing the permissions of the schema and table, but this didn't seem to help, even though I'm accessing the database with the same user as the program itself (at least in dbVis). Is there a setting I can change in my database that allows me to have "root" access to all session in my database?
Asked by newenglander
(1075 rep)
Aug 31, 2011, 09:10 AM
Last activity: Jun 25, 2025, 02:04 PM
Last activity: Jun 25, 2025, 02:04 PM