Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the all tables, triggers, fuctions available in my database - Mailing list pgsql-novice

From Wojtek
Subject Re: How to get the all tables, triggers, fuctions available in my database
Date
Msg-id 4A8FE9FF.6030108@twine.pl
Whole thread Raw
In response to How to get the all tables, triggers, fuctions available in my database  (Jignesh Shah <jignesh.shah1980@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Michael Rowan
Date:
Subject: GROUP BY difficulties
Next
From: Wolfgang Keller
Date:
Subject: Generate LaTeX doc from PostgreSQL (autodoc)?