Postgres Pro
Downloads
Home   >   mailing lists

Checking for existence of table - Mailing list pgsql-sql

From Paul McGarry
Subject Checking for existence of table
Date
Msg-id 396ACCA1.8E354519@opentec.com.au
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Patrik Kudo
Date:
Subject: Re: Creating timestamps in queries?
Next
From: "Adam Walczykiewicz"
Date:
Subject: SQL-92 SQLSTATE in PostgreSQL ?!