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

[Tadipathri Raghu <traghu.dba@xxxxxxxxx>]

Hi Yogi Yang,

 

Psql is a very strong tool, and easy to use. Please find the answers for your queries

>>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

postgres=#\d{t|i|s|v|S|g|n}     

 

you can use any of the things as per your requirement

>>4. Retrieve list of all Login Roles
>>5. Structure of a Table

postgres=# \d  <tablename>

 

Hope this will help you out

 

Regards

Raghavendar

 

TIA

Yogi Yang

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general