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)?
On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Jaime Casanova <[EMAIL PROTECTED]> writes:
> > On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote:
> >> 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
> >> n
Jaime Casanova <[EMAIL PROTECTED]> writes:
> On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote:
>> 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)?
> SELECT n.nspname as "Schema", c
On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote:
>
> On 25 Jan 2006, at 14:17, Jaime Casanova wrote:
>
> >> How can I determine what temporary tables exist in my session,
> >> bearing in mind that other sessions contain temp tables using the
> >> same names?
> >>
> >
> > just the ones you have cr
On 25 Jan 2006, at 14:17, Jaime Casanova wrote:
How can I determine what temporary tables exist in my session,
bearing in mind that other sessions contain temp tables using the
same names?
just the ones you have created in your session, temporary tables in
other sessions are invisible to you
> How can I determine what temporary tables exist in my session,
> bearing in mind that other sessions contain temp tables using the
> same names?
>
just the ones you have created in your session, temporary tables in
other sessions are invisible to you...
--
regards,
Jaime Casanova
(DBA: DataBase