Re: [SQL] How to find a temporary table

2006-01-27 Thread Mario Splivalo
On Fri, 2006-01-27 at 04:48 -0800, Emil Rachovsky 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 > tried some things but I receive mixed results of > tables from differe

[SQL] 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.