Sample Header Ad - 728x90

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