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@xxxxxxxxx> 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@xxxxxxxxxxxxxx so that
your
message can get through to the mailing list cleanly
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
