On Fri, Apr 20, 2012 at 11:07 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
>> well, arguably you should already know somehow. but if you don't,
>> query information_schema.views for a table_name with a table_schema
>> LIKE 'pg_temp%'.
>
> Not sure that is safe --- won't the info schema also show temp views
> of other sessions?
nope, it works (you only get to see your own temporary views
information_schema). i guess you could make an arguable case to fold
the temp schema name to a constant to hide the pg_temp_zz
implementation detail.
merlin