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@yandex.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@postgresql.org so that
> your
>        message can get through to the mailing list cleanly
>

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