Saturday, January 07, 2006

Index information from information_schema

This blog post has moved. Please find it at:

http://www.mpopp.net/2006/01/index-information-from-information_schema/.

2 comments:

Robert Treat said...

Did you ever get this query working on postgresql? I tried running what you have on 8.1 and actually think I've encountered a bug, so I'm curious if you ever got it. (Indexes are typically a pain to work on cross-db given there is no standard for them)

BTW, pg statistic information can be found in the pg_stat_* views... heres a link: http://www.postgresql.org/docs/current/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

PS. You knew deep down it was a mysql extension and not something missing in postgresql didn't you?

sujithkumar said...

fine.can there be any query that accepts as input a database name and outputs all the field details of the tables in it