>If you don't care whether the table is temporary or not then you
>could simply test if it's visible:
>
>SELECT *
>FROM pg_class
>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.
Thanks
Michael