Postgres Pro
Downloads
Home   >   mailing lists

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

From Jignesh Shah
Subject How to get the all tables, triggers, fuctions available in my database
Date
Msg-id c11950270908220544n4ad7c0a1mdefa32578e8edeb@mail.gmail.com
Whole thread Raw
Responses Re: How to get the all tables, triggers, fuctions available in my database  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: How to get the all tables, triggers, fuctions available in my database  (Wojtek <foo@twine.pl>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: Group By Statement - how to display fields not in the statement?
Next
From: Andreas Kretschmer
Date:
Subject: Re: How to get the all tables, triggers, fuctions available in my database