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:
- Open a PostgreSQL service whose sessions have created temporary tables over time.
- Go to Database → Data and open the Schema picker.
- 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.
Attachments
0 Threads mention this feature
0 Replies