if exists?

Vincent Stoessel writes:
 > Is there an sql query that I can use on postgres that will tell
 > me if a table exists? I'm writing a perl script thatr creates a table.
 > But I want it to rename a table with the same name if it finds an
 > existing one.

Something like:

 SELECT COUNT(relname) FROM pg_class WHERE relname = 'tablename';

Regards, Lee Kindness