Обсуждение: clean database

Поиск
Список
Период
Сортировка

clean database

От
"Ryan Mchale"
Дата:
Hi,

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

Ryan

Re: [GENERAL] clean database

От
Tom Good
Дата:
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

От
Jeong Jae Ick:정재익:
Дата:
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========================================