if exists? - Mailing list pgsql-general

From Lee Kindness
Subject if exists?
Date
Msg-id 15583.56086.82928.173176@kelvin.csl.co.uk
Whole thread Raw
In response to if exists?  (Vincent Stoessel <vincent@xaymaca.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "murphy pope"
Date:
Subject: Re: Why is ALLOW_ABSOLUTE_DBPATHS unsafe?
Next
From: "Marin Dimitrov"
Date:
Subject: Re: if exists?