check if database is correctly created

["Alain Roger" <raf.news@xxxxxxxxx>]

Hi,

 

i would like to check (via PHP or C#) if my database has been correctly created.

for that i use the following SQL :

select * from pg_tables where tablename = 'xxx' AND schemaname = 'yyy';

this i repeat till i check all tables.

 

But how to check sequences, index, functions, and so on ?

 

thanks a lot,

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.3
Apache 2.2.4
PHP 5.2.3