Re: Discover temporary INDEX/TABLE name

"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