Hide PostgreSQL temporary schemas in the Database schema picker
loli-nexus
PROOP

7 hours ago

In Database → Data, the Schema picker lists PostgreSQL internal namespaces (pg_temp_N and pg_toast_temp_N) alongside application schemas. One of our databases currently shows 480 pairs, making application schemas difficult to find.

Steps to reproduce:

  1. Open a PostgreSQL service whose sessions have created temporary tables over time.
  2. Go to Database → Data and open the Schema picker.
  3. Observe the internal temporary namespaces mixed with application schemas.

Expected: Hide PostgreSQL internal temporary schemas by default, with an option to show them when needed. A searchable picker would also help.

These namespaces are retained and reused by PostgreSQL after the temporary tables are gone, so deleting them from the database is not a suitable workaround. Please filter them in the data viewer.

Additional usability issue: The Schema picker refreshes while I scroll up to select a schema near the beginning. It jumps back to the end before I can click the schema, making some schemas effectively impossible to select.

Expected: Keep the scroll position stable during refresh.

image.png

Attachments

Under Review

0 Threads mention this feature

0 Replies

Welcome!

Sign in to your Railway account to join the conversation.

Loading...