In article <3C91F9B7-398C-464F-A5F1-C6A790DC1CC7(at)lumison(dot)net>,
James Croft <james(dot)croft(at)lumison(dot)net> wrote:
[given a bunch of temporary tables called session_data]
% How can I determine if one of the above relations is a temporary
% table in the current session (one of them, the first in ns 2200, is a
% normal permanent table)?
If there's data in the table, you could "select tableoid from session_data
limit 1", then check the namespace corresponding to that table.
--
Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com