Re: Which backend using which pg_temp_N schema?

Jerry Sievers <gsievers19(at)comcast(dot)net> writes:
> Yep thanks... but IMO something that simply exposes whatever internal
> registry of temp schemas/PIDs (which I presume must exist)

Not really. There are a couple of ways that one could identify a
session's "BackendId", which is the "N" in the "pg_temp_N" name of
the temp schema that it would use if it uses one. But I do not think
there's any terribly reliable way to tell from outside the session
whether it has actually done anything with the temp schema. If it
hasn't, then at least in principle there could be objects in the
schema that are left over from a crashed session that previously had
the same BackendId. We only make an effort to clean out such objects
at the time that a session first creates a temp object.

In any case, I think you're right that this isn't exposed at the SQL
level presently.

regards, tom lane