Re: How to get the all tables, triggers, fuctions available in my database

Jignesh Shah wrote:
> Hi,
>
> I have connected to my databade "mydb". I want to check how many
> tables triggers, fuctions available in this database. What commands I
> should use for this? Is there any system table that PostgreSQL
> maintains to which I can query for this?
>
> Thanks,
> Jignesh
Hi,

try exploring pg_catalog

http://www.postgresql.org/docs/8.3/static/catalogs.html

Regards,
foo