Re: Temporary tables ?access possible. - Mailing list pgsql-novice

From Tom Lane
Subject Re: Temporary tables ?access possible.
Date
Msg-id 22031.1339628027@sss.pgh.pa.us
Whole thread Raw
In response to Temporary tables ?access possible.  (Richard Terry <rterry@internode.on.net>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Richard Terry
Date:
Subject: Temporary tables ?access possible.
Next
From: Daniel Staal
Date:
Subject: Re: coalesce in plpgsql, and other style questions