pg_class to check if table exists

dd May 10, 2006 Reply

For functionality similar to mysql SHOW TABLES use: select * from information_schema.tables where table_schema='public' and table_type='BASE TABLE' .