Drop All the Databases

Started by Nonameover 19 years ago3 messagesgeneral
Jump to latest
#1Noname
Abu_Kamruzzaman@baruch.cuny.edu

Is there any command to drop all the database at once>
drop database dbname
drops the individual database.
I am using ver8.1
thanks,

#2Ron Johnson
ron.l.johnson@cox.net
In reply to: Noname (#1)
Re: Drop All the Databases

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/18/06 14:08, Abu_Kamruzzaman@baruch.cuny.edu wrote:

Is there any command to drop all the database at once>
drop database dbname
drops the individual database.
I am using ver8.1
thanks,

DROP DATABASE <db_name>;

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNo9IS9HxQb37XmcRAsb9AJwOapKW61ZWX9fkqWxI3LwhV3EmEwCg4sfS
UIokaAXKaLg4yt7A/9kChl8=
=Q7lT
-----END PGP SIGNATURE-----

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: Drop All the Databases

Abu_Kamruzzaman@baruch.cuny.edu writes:

Is there any command to drop all the database at once>

shutdown postmaster, rm -rf $PGDATA, initdb, start postmaster ...

regards, tom lane