Temporary table in pgAdmin

Question

I use pgAdmin for my Postgres 8.4 database, and I was wondering where (any table / schema / etc ...) can I find a list of currently used temporary tables? I guess there should be a place where I can find him.

They are not present in the table directory object or in the views , any other suggestions?

Answer 1

Postgres creates a temporary schema for temporary tables called "pg_temp_ #", you can see it with psql ...

create temp table mytemptable(name varchar); select c.relname from pg_namespace n join pg_class c on n.oid=c.relnamespace where n.nspname='pg_temp_1'; 

You can list your schemas running "\ dn" in psql.

Hope this helps.