How about if exists (select .. from ..) On 11/14/05, Jaime Casanova <[EMAIL PROTECTED]> wrote: > On 11/14/05, P.M <[EMAIL PROTECTED]> 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