Search Postgresql Archives

Re: IF EXISTS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Nov 14, 2005 at 13:20:59 -0800,
  "P.M" <pmdanger@xxxxxxxxx> wrote:
> 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";

I don't believe there is a feature like that for users (roles) or databases.
The normal thing to do would be to have the application try to delete the
object and ignore the problem if things fail. If this is happening in a larger
transaction that you don't want rolled back, then you can use savepoints.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux