Saturday, January 07, 2006

Index information from information_schema

This blog post has moved. Please find it at:


Anonymous 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:

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