Thread

clean database

Ryan Mchale <sdecoop2@nortel.ca> — 1998-08-11T11:17:00Z
```
Hi,

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

Ryan
```

Re: [GENERAL] clean database

Thomas Good <tomg@nrnet.org> — 1998-08-11T17:04:38Z

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

Re: [GENERAL] clean database

root@advance.sarang.net — 1998-08-12T07:20:45Z

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========================================