Postgres Pro
Downloads
Home   >   mailing lists

Re: getting information of tables and indexes - Mailing list pgsql-general

From Sean Davis
Subject Re: getting information of tables and indexes
Date
Msg-id 001601c537df$d36232f0$5179f345@WATSON
Whole thread Raw
In response to getting information of tables and indexes  ("Srikanth Utpala (Virinchi)" <SrikanthUtpala@virinchi.com>)
Responses Re: getting information of tables and indexes
List pgsql-general
Tree view
You can query the information schema:
 
 
More specifically:
 
 
Hope that answers your question.
 
Sean
 
----- Original Message -----
Sent: Friday, April 01, 2005 1:42 AM
Subject: [GENERAL] getting information of tables and indexes

Hi

                I am Srikanth.  I want to get the information about all tables in the existing postgresql . I want list all the tables and its columns information by executing a simple SQL statement like in oracle. We have a view like “user_tab_columns” in oracle to get all the information of  the tables of a user. Can we have nay option like this in postgresql can u help out in this.

            And also I want to get all constraints in the database and also respective parent tables and parent columns for the referential constrains. Please help in this issues.

            I will be thankful to you for your helping in this

 

Regards,

Srikanth.Utpala

  

 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-general by date:

Previous
From: Paul Tillotson
Date:
Subject: Re: getting information of tables and indexes
Next
From: Tom Lane
Date:
Subject: Re: Crazy Multiplication Issue