From: | Paul Tillotson <pntil(at)shentel(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: getting information of tables and indexes |
Date: | 2005-04-03 00:02:18 |
Message-ID: | 424F328A.4060703@shentel.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SELECT * FROM information_schema.tables;
SELECT * FROM information_schema.columns;
These should have most of the information you need.
Regards,
Paul Tillotson
Srikanth Utpala (Virinchi) wrote:
> 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**
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-03 00:13:30 | Re: Crazy Multiplication Issue |
Previous Message | Sean Davis | 2005-04-02 23:58:11 | Re: getting information of tables and indexes |