Обсуждение: 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-----

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