On Fri, Apr 20, 2012 at 11:07 AM, Tom Lane <[email protected]> wrote: > Merlin Moncure <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
