Temporary Tables
If you use temporary tables in PostgreSQL or Redshift, there are two preferences in PopSQL that will help you have a better experience. For now, we only support temporary tables when you use a direct connection in the desktop app.
- Visit your PopSQL preferences.
- Disable concurrent queries, so only one query runs at a time. This way, you're guaranteed to stay in one session when you
create
andselect
from your temporary table. - Increase your idle timeout to a high number, like
28800
(8 hours). This way, when youcreate
a temporary table, it won't get dropped for 8 hours, giving you enough time to use it.

Updated over 1 year ago