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**
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
