Re: determine if a table exists

>
> 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