Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group