"dfx" <dfx(at)dfx(dot)it> writes:
> how I can check the existance of temporary table?
> I.e. wich query I have to use to know if MY_TEMP_TABLE exists?
As of 8.2 you can do
SELECT ... FROM pg_class
WHERE relname = 'whatever' AND relnamespace = pg_my_temp_schema();
In earlier releases pg_my_temp_schema() isn't built in, so you have
to do some pushups to determine which schema is your temp schema.
regards, tom lane