>If you don't care whether the table is temporary or not then you
>could simply test if it's visible:
>WHERE relname = 'foo'
> AND relkind = 'r'
> AND pg_table_is_visible(oid);
Ignore my last post that pg_table_is_visible didn't work, I created the
table but forgot the keyword temp :( .. Guess its time for me to goto bed.
This is exactly what I'm looking for.
In response to
pgsql-novice by date
|Next:||From: John DeSoi||Date: 2005-02-04 07:02:19|
|Subject: Re: Installation tool|
|Previous:||From: Michael Guerin||Date: 2005-02-04 04:10:40|
|Subject: Re: Temp table exists test??|