On Tue, 23 Aug 2022 at 05:29, Greg Stark <stark@mit.edu> wrote:
Having this function would be great (I admit I never responded because I never figured out if your suggestion was right or not:). But should it also be added to the pg_stat_activity view? Perhaps even just in the SQL view using the function.
Alternately should pg_stat_activity show the actual temp schema name instead of the id? I don't recall if it's visible outside the backend but if it is, could pg_stat_activity show whether the temp schema is actually attached or not?
Would it work to cast the schema oid to type regnamespace? Then the actual data (numeric oid) would be present in the view, but it would display as text.