Postgres Pro
Downloads
Home   >   mailing lists

Which backend using which pg_temp_N schema? - Mailing list pgsql-general

From Jerry Sievers
Subject Which backend using which pg_temp_N schema?
Date
Msg-id 87o9go3nok.fsf@jsievers.enova.com
Whole thread Raw
Responses Re: Which backend using which pg_temp_N schema?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
Was just studying a legacy DB to learn about temp table activity.

Felt like being able to tie temp schemas to live backends s/b useful but
then didn't find a function/view for doing this.

A quic \df for functions with names likely to be fruitful revealed
nothing.  Did likewise for sysinfo views.

Am I missing it or does feature not exist?

Thx

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Reset the cursor to start from the record 1
Next
From: Peter Geoghegan
Date:
Subject: Re: Code of Conduct plan