clean database

On 11 Aug 1998, Ryan Mchale wrote:

Hi,

What's the clean command called? (To clean the db?)

Ryan

We use a _vacuum_ cleaner. ;-)

Cheers,
Tom

----------- Sisters of Charity Medical Center ----------
Department of Psychiatry
----
Thomas Good, System Administrator <tomg@q8.nrnet.org>
North Richmond CMHC/Residential Services Phone: 718-354-5528
75 Vanderbilt Ave, Quarters 8 Fax: 718-354-5056
Staten Island, NY 10304 www.panix.com/~ugd
----
Powered by PostgreSQL 6.3.2 / Perl 5.004 / DBI-0.91::DBD-PG-0.69

What's the clean command called? (To clean the db?)

Vacuum

On 11 Aug 1998, Ryan Mchale wrote:

Hi,

What's the clean command called? (To clean the db?)

Ryan

If you want to remove all databases then use 'destroydb'.
If you want to remove tables in database then use 'drop table'.

Explanation for each command are listed in man page.
( man destroydb / man drop_table )

==========ooOO /. .\ OOoo======================================
| http://advance.sarang.net
The will is to do something. | advance@advance.sarang.net
The truth is power of mine. | advances@nownuri.net
| ICQ# : 15760421

ADVANCE in My World >> | Phone: +82-0551-71-2318

| C.P. : +82-011-871-1959
============OOo./-\.oOO========================================

-----Original Message-----
From: Jeong Jae Ick:������: <root@advance.sarang.net>
To: Ryan Mchale <sdecoop2@nortel.ca>
Cc: <pgsql-general@postgreSQL.org>
Date: Wednesday, August 12, 1998 03:36
Subject: Re: [GENERAL] clean database

On 11 Aug 1998, Ryan Mchale wrote:

Hi,

What's the clean command called? (To clean the db?)

Ryan

If you want to remove all databases then use 'destroydb'.
If you want to remove tables in database then use 'drop table'.

Sometimes you clean the house, sometimes you burn the whole house down (-;
...james