IF EXISTS

From: "P(dot)M" <pmdanger(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: IF EXISTS
Date: 2005-11-14 21:20:59
Message-ID: 20051114212059.40218.qmail@web33208.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I would like to know if "IF EXISTS" exists under
postgresql ?
because i did not find it.

before to create users or database, i would like to be
sure that they do not exist already.

so how can i test it and do something like :

IF EXISTS database "test" DROP database "test";

thanks a lot,
Maileen


__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-11-14 21:35:34 Re: IF EXISTS
Previous Message John DeSoi 2005-11-14 21:02:30 Re: [8.1] "drop table" in plpgsql function