On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txt...@gmail.com> wrote: > When a temp table is created I see a pg_temp_NNN (for example > pg_temp_3, pg_toast_temp_3) schemas created when/why are additional > temp schemas created( pg_temp_4/pg_toast_temp_4)? > > Temporary schemas are isolated to the session they are created in. Hence, you get multiple temporary schemas if you have concurrent sessions using temporary objects.
David J.
