Hello, I answered my own question. :) I continued looking last night after I posted this and found a really easy way to get this info...
select * from pg_indexes where tablename like 'YOURTABLENAME' This will give you the DDL to create your indexes. Regards, Paul Paul Silveira wrote: > > Hello, > > Does anyone have any good code to extract the metadata needed to create > indexes on a specific table? The Client Tools (like pgadmin-III) presents > that code so I'm sure it's extractable but could not find it in my trace > that I ran while operating pgadmin... > > Thanks in advance, > > Paul > > -- View this message in context: http://www.nabble.com/Extracting-Index-Creation-Script-tf4680848.html#a13384579 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
