Re: getting information of tables and indexes
От | Sean Davis |
---|---|
Тема | Re: getting information of tables and indexes |
Дата | |
Msg-id | 001601c537df$d36232f0$5179f345@WATSON обсуждение исходный текст |
Ответ на | getting information of tables and indexes ("Srikanth Utpala (Virinchi)" <SrikanthUtpala@virinchi.com>) |
Ответы |
Re: getting information of tables and indexes
|
Список | pgsql-general |
----- Original Message -----Sent: Friday, April 01, 2005 1:42 AMSubject: [GENERAL] getting information of tables and indexesHi
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 по дате отправления: