Postgres Pro
Downloads
Home   >   mailing lists

Drop/ Alter index if exist - Mailing list pgsql-general

From Pau Marc Munoz Torres
Subject Drop/ Alter index if exist
Date
Msg-id 19b5841a0912220239i56433054sa2ddb4a8bc26c42b@mail.gmail.com
Whole thread Raw
Responses Re: Drop/ Alter index if exist  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-general
Tree view
Hi every body

 there is some way to delete or rename an index only if this index exists?

something like

"alter index index rename to pepe if exists"

thanks

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional  
Institut de  Biotecnologia   i Biomedicina Vicent Villar                                    
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
             
telèfon: 93 5812807
Email : paumarc.munoz@bioinf.uab.cat

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Charset Win1250 on Windows and Ubuntu
Next
From: Filip Rembiałkowski
Date:
Subject: Re: \dt doesn't show all relations in user's schemas (8.4.2)