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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073