In article <3C91F9B7-398C-464F-A5F1-C6A790DC1CC7@lumison.net>,
James Croft <james.croft@lumison.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@interlog.com
