How to retrive List of Tables in a Database using... - Mailing list pgsql-general

Hello,

I am new to pgSQL. I would like to know if there is a way to do the
following using pure SQL:
1. Retrieve list of all Tables in a database
2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
3. Retrieve list of all Group Roles
4. Retrieve list of all Login Roles
5. Structure of a Table

TIA

Yogi Yang

pgsql-general by date:

Previous
From: Tadipathri Raghu
Date:
Subject: "\d pg_class" fails in PG 8.4
Next
From: Tom Lane
Date:
Subject: Re: "\d pg_class" fails in PG 8.4