Re: [GENERAL] How to find a temporary table

2006-01-27 Thread Pandurangan R S
http://archives.postgresql.org/pgsql-general/2006-01/msg01259.php On 1/27/06, Emil Rachovsky <[EMAIL PROTECTED]> wrote: > > Hi, > I am using PostgreSQL 8.1.0 . How can I find a temp > table from my session, having the name of the table? > Can anyone show me what query should I execute? I've > tri

[GENERAL] How to find a temporary table

2006-01-27 Thread Emil Rachovsky
Hi, I am using PostgreSQL 8.1.0 . How can I find a temp table from my session, having the name of the table? Can anyone show me what query should I execute? I've tried some things but I receive mixed results of tables from different sessions, which is strange.