How about if exists (select .. from ..) On 11/14/05, Jaime Casanova <systemguards@xxxxxxxxx> wrote:> On 11/14/05, 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";> >> > thanks a lot,> > Maileen> >> >>> something in shell is fine?>> ---------SCRIPT BEGIN HERE ------------> #!/bin/sh>> psql template1 -A -t -c "SELECT datname FROM pg_database WHERE> datname = 'test'" | while read D ; do> dropdb test> # or you can do> # psql template1 -c "DROP DATABASE test"> # whatever you feel comfortable with> done>> createdb test> ---------SCRIPT END HERE ------------>>> --> regards,> Jaime Casanova> (DBA: DataBase Aniquilator ;)>> ---------------------------(end of broadcast)---------------------------> TIP 9: In versions below 8.0, the planner will ignore your desire to> choose an index scan if your joining column's datatypes do not> match> ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
