Script to recreate indexes?
Script to recreate indexes?
От:
Dani Oderbolz <oderbolz@ecologic.de>
Дата:
Hi guys, I wnated to write a nice littel script to regenerate Indexes, but I am struggling with the Array type... (Can anydody tell me why the PostgreSQL Catalog does use this non-relational stuff??) Does anyone have a script either showing the Array stuff or (even better :-) the creation of Index definitions out of a given catalog? Thanks a lot! Regards, Dani
Re: Script to recreate indexes?
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Have you looked in the src/contrib/reindex directory? --------------------------------------------------------------------------- Dani Oderbolz wrote: > Hi guys, > I wnated to write a nice littel script to regenerate Indexes, > but I am struggling with the Array type... > (Can anydody tell me why the PostgreSQL Catalog does use > this non-relational stuff??) > Does anyone have a script either showing the Array stuff > or (even better :-) the creation of Index definitions > out of a given catalog? > > Thanks a lot! > > Regards, Dani > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073