Which backend using which pg_temp_N schema?

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Which backend using which pg_temp_N schema?
Date: 2018-06-05 21:53:31
Message-ID: 87o9go3nok.fsf@jsievers.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)consulting(at)comcast(dot)net
p: 312.241.7800

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2018-06-05 22:20:15 Re: Code of Conduct plan
Previous Message David G. Johnston 2018-06-05 21:45:53 Re: Reset the cursor to start from the record 1