Received: from erm1.u-strasbg.fr (erm1.u-strasbg.fr [130.79.74.61]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eARBP3t38591 for ; Mon, 27 Nov 2000 06:25:03 -0500 (EST) (envelope-from bboett@erm1.u-strasbg.fr) Received: (qmail 27482 invoked by uid 501); 27 Nov 2000 11:44:23 -0000 Date: Mon, 27 Nov 2000 12:44:23 +0100 From: Bruno Boettcher To: pgsql-sql@postgresql.org Subject: removing a DB?? Message-ID: <20001127124423.A26525@erm1.u-strasbg.fr> Reply-To: bboett@erm1.u-strasbg.fr Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i X-Archive-Number: 200011/236 X-Sequence-Number: 267 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....