Re: Discover temporary INDEX/TABLE name

"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