On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txtoth(at)gmail(dot)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.