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

From Yogi Yang 007
Subject How to retrive List of Tables in a Database using...
Date
Msg-id 4BAAE623.8040306@gmail.com
Whole thread Raw
Responses Re: How to retrive List of Tables in a Database using...  (Tadipathri Raghu <traghu.dba@gmail.com>)
Re: How to retrive List of Tables in a Database using...  (John R Pierce <pierce@hogranch.com>)
Re: How to retrive List of Tables in a Database using...  (John R Pierce <pierce@hogranch.com>)
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