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
