Cleaning up index names

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Cleaning up index names
Date: 2011-10-20 19:13:52
Message-ID: CANPAkgvzeEtPBm5a2fo4rnsKuCiqwKdSY+UOhco5GYGX_HNsgA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a database which was created with DDL from several different tools.
Each one seems to have had their own naming convention for indexes. I'd
like to rename them to be consistent. Has anyone seen a tool or put
together a script to do this based on the catalog data?

__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com

<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2011-10-20 19:14:27 Re: Extraneous Files
Previous Message Henry Drexler 2011-10-20 19:03:48 plpgsql at what point does the knowledge of the query come in?