Also take a look at the queries that psql performs for \d (start psql
with the -E option).
On Nov 15, 2006, at 2:11 PM, Jerry Sievers wrote:
"Ilja Golshtein" <[EMAIL PROTECTED]> writes:
Hello!
How could I find out if a temporary table
(or index on a temporary table) was created
by current
"Ilja Golshtein" <[EMAIL PROTECTED]> writes:
> Hello!
>
> >How could I find out if a temporary table
> >(or index on a temporary table) was created
> >by current session?
>
> May be the better question to ask is
> how one can find out the temporary
> schema name associated with the session.
s
Ilja Golshtein skrev:
Hello!
How could I find out if a temporary table
(or index on a temporary table) was created
by current session?
The problem is something like
SELECT COUNT(*) FROM PG_INDEXES WHERE INDEXNAME='tmpind1'
does not work since temporary indexes from other sessions
are visible
Hello!
>How could I find out if a temporary table
>(or index on a temporary table) was created
>by current session?
May be the better question to ask is
how one can find out the temporary
schema name associated with the session.
--
Best regards
Ilja Golshtein
---(end
Hello!
How could I find out if a temporary table
(or index on a temporary table) was created
by current session?
The problem is something like
SELECT COUNT(*) FROM PG_INDEXES WHERE INDEXNAME='tmpind1'
does not work since temporary indexes from other sessions
are visible. I need a way to make a
