On Fri, Apr 20, 2012 at 11:07 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Merlin Moncure <mmonc...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
