removing a DB??
От | Bruno Boettcher |
---|---|
Тема | removing a DB?? |
Дата | |
Msg-id | 20001127124423.A26525@erm1.u-strasbg.fr обсуждение исходный текст |
Список | pgsql-sql |
hello, i have a nice command to create a db 'createdb', but hows when you want to get rid of a DB?? searched for a removedb script.... Took me some time to read through the man page, find out how the command actually works, look up the SQL commands and find out that there's also a DROP DATABASE SQL-command... And then looking up that there'S really a dropdb command.... would be really nice if in the man page there was a short ref, telling me about related commands..... Then the question arouse, if i can create and destroy databases from SQL, building my install script, it would be nice to test for the presence of a DB and in case of inexistence, create it on the fly. For this it would be nice if i could have found for each possible command in psql the SQL counterpart, notably, how to list all available DB's through SQL. BTW shouldn't \l display also the internal DB's ? If it would i could have searched for the right table.... -- ciao bboett ============================================================== bboett@earthling.net http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett =============================================================== the total amount of intelligence on earth is constant. human population is growing....
В списке pgsql-sql по дате отправления: