Re: Discover temporary INDEX/TABLE name

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" <ilejn(at)yandex(dot)ru> 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.
>
> select (current_schemas(true))[1];
>
> In the typical case;
>
> Will be pg_temp_* if you have created a temp object
> or pg_catalog otherwise.
>
> HTH
>
>> --
>> Best regards
>> Ilja Golshtein
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>
> --
> ----------------------------------------------------------------------
> ---------
> Jerry Sievers 305 854-3001 (home) Production Database
> Administrator
> 305 321-1144 (mobil WWW E-Commerce Consultant
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>

--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)