Drop/ Alter index if exist

From: Pau Marc Munoz Torres <paumarc(at)gmail(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Drop/ Alter index if exist
Date: 2009-12-22 10:39:06
Message-ID: 19b5841a0912220239i56433054sa2ddb4a8bc26c42b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)munoz(at)bioinf(dot)uab(dot)cat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2009-12-22 13:08:53 Re: \dt doesn't show all relations in user's schemas (8.4.2)
Previous Message Thomas 2009-12-22 10:19:12 postgres: writer process,what does this process actually do?