Thread: Checking for existence of table

Hello,

Is it possible to check for the existence of a table within PL/pgSQL?

Would 
select count(*) from pg_class where relname='name' and 
reltype='0'
be the answer to this question?

-- 
Paul McGarry            mailto:paulm@opentec.com.au 
Systems Integrator      http://www.opentec.com.au 
Opentec Pty Ltd         http://www.iebusiness.com.au
6 Lyon Park Road        Phone: (02) 9878 1744 
North Ryde NSW 2113     Fax:   (02) 9878 1755