Received: from neptun.sns-felb.debis.de (neptun.sns-felb.debis.de [53.122.101.2]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eARBYFt39182 for ; Mon, 27 Nov 2000 06:34:15 -0500 (EST) (envelope-from jhartwig@debis.com) Received: by neptun.sns-felb.debis.de; id MAA03125; Mon, 27 Nov 2000 12:38:44 +0100 Received: from unknown(53.113.82.10) by neptun.sns-felb.debis.de via smap (V5.0) id xma003114; Mon, 27 Nov 00 12:38:39 +0100 Received: from mail1.b3.dsh.de (localhost [127.0.0.1]) by dshmail1.dsh.de (8.9.1/8.8.7) with ESMTP id MAA20126; Mon, 27 Nov 2000 12:34:22 +0100 (MET) Received: from debis.com ([138.201.143.121]) by mail1.b3.dsh.de (8.10.0/8.10.0) with ESMTP id eARBYMh00483; Mon, 27 Nov 2000 12:34:22 +0100 Message-ID: <3A2246CE.E8560B97@debis.com> Date: Mon, 27 Nov 2000 12:34:38 +0100 From: Jens Hartwig Organization: debis Systemhaus GEI X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de MIME-Version: 1.0 To: bboett@erm1.u-strasbg.fr CC: pgsql-sql@postgresql.org Subject: Re: removing a DB?? References: <20001127124423.A26525@erm1.u-strasbg.fr> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200011/237 X-Sequence-Number: 268 Hello Bruno, you get a list of all available databases by issuing a query on "pg_database": select * from pg_database; What do you mean with "internal DB's"? Regards, Jens Bruno Boettcher schrieb: > > 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.... -- Herzliche Grüße, Jens Hartwig ============================================= Jens Hartwig --------------------------------------------- debis Systemhaus GEI mbH 10875 Berlin Tel. : +49 (0)30 2554-3282 Fax : +49 (0)30 2554-3187 Mobil : +49 (0)170 167-2648 E-Mail : jhartwig@debis.com =============================================