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 private connection in the desktop app.

  1. Visit your PopSQL preferences.
  2. Disable concurrent queries, so only one query runs at a time. This way 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.

alt text

Ready for a modern SQL editor?