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

From: Wojtek <foo(at)twine(dot)pl>
To: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
Cc: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to get the all tables, triggers, fuctions available in my database
Date: 2009-08-22 12:52:15
Message-ID: 4A8FE9FF.6030108@twine.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2009-08-22 15:13:15 Re: How to get the all tables, triggers, fuctions available in my database
Previous Message Jignesh Shah 2009-08-22 12:44:25 How to get the all tables, triggers, fuctions available in my database