In article <[EMAIL PROTECTED]>,
James Croft <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
