How to retrive List of Tables in a Database using...

From: Yogi Yang 007 <yogiyang007(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to retrive List of Tables in a Database using...
Date: 2010-03-25 04:27:15
Message-ID: 4BAAE623.8040306@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-25 04:33:09 Re: "\d pg_class" fails in PG 8.4
Previous Message Tadipathri Raghu 2010-03-25 04:22:32 "\d pg_class" fails in PG 8.4