Re: Temporary tables and miscellaneous schemas

Sean Chittenden wrote:
> > > If you see a pg_temp_* for every connection, that is a little
> > > overwhelming. pg_toast and stuff aren't really too bad. Is there
> > > any way to access your local temp schema in a way that doesn't
> > > show the others? Could we use backend_pid in the query and show
> > > them only their own?
> >
> > I have created the following patch for 7.5. It has \dn show only
> > your local pg_temp_* schema, and only if you own it --- there might
> > be an old temp schema around from an old backend.
> >
> > This patch requires a new function pg_stat_backend_id which returns
> > your current slot id (not your pid) --- that would be separate
> > addition.
>
> If by slot, you mean connection ID, then this sounds like a good
> compromise/patch to me. -sc

Yep, that's what it is.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073