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.
Is it possible.
Thanks.