Thread: Temporary tables ?access possible.

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.

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