Re: determine if a table exists - Mailing list pgsql-sql

> 
> how do i determine if a table exists using select statement
> i want to find out if it exists if not ill create it if yes then ill do
> some editing with it
> TIA
> 
do 
SELECT relname FROM pg_class       WHERE relkind='r'       AND relname !~ '^pg_'       AND relname !~ '^pga_'       AND
relname!~ '^pgadmin_';
 

You should also refer to Chapter 3. System Catalogs 
in the Documentation. 

Regards, Christoph