>
> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
