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

Jignesh Shah <jignesh.shah1980@gmail.com> 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?

There are some tables/views in information_schema.* and pg_* and, of
course, our documentation.

For instance, information_schema.tables contains all tables.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

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