Richard Terry <rterry@internode.on.net> writes:
> select pn.nspname, pc.relname from pg_class pc, pg_namespace pn where
> pc.relnamespace = pn.oid and pc.relname ilike 'my-temp-table-name';
> This gives the the details, but I can't still access the contents.
If you mean access the contents from another session, no you can't,
at least not with any reliability.
regards, tom lane