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 whether you use the desktop or web app.

  1. Visit your PopSQL preferences.
  2. Disable concurrent queries, so only one query runs at a time. This way, you're guaranteed to stay in one session when you create and select from your temporary table.
  3. Increase your idle timeout to a high number, like 28800 (8 hours). This way, when you create a temporary table, it won't get dropped for 8 hours, giving you enough time to use it.
1490

Note: Temporary tables exist only in the session in which they were created (see documentation for Postgres and Snowflake). PopSQL indicates when a session is disconnected with a visual indicator above the run button, with a tooltip explaining that the next run will use a new session.


Cookie settings