Re: empty a database

Поиск
Список
Период
Сортировка
От Dick Davies
Тема Re: empty a database
Дата
Msg-id 20050216231552.GH64242@eris.tenfour
обсуждение исходный текст
Ответ на Re: empty a database  (Christopher Browne <cbbrowne@acm.org>)
Список pgsql-admin
* Christopher Browne <cbbrowne@acm.org> [0223 20:23]:
> Clinging to sanity, rasputnik@hellooperator.net (Dick Davies) mumbled into her beard:
> > Is there a neat way to clean out a database via SQL commands?
> >
> > i.e. get rid of tables, sequences, integers, etc.
> >
> > At present I'm using dropdb/createdb, but thats' far from ideal
> > and I think it's causing postgres to do more mork than it needs to...
>
> If you truly need for all of the objects to go away, dropping the
> database seems like a reasonable way to do this.  I'm not sure what
> work you are imagining is "too much" or "unnecessary."

It just seems a bit extreme, but the alternatives are all a bit gnarly,
so think I'll live with it....

Thanks for all the suggestions, though, everybody.

--
'The old 'give em a Linux box and they think they're Jean-Luc Picard' syndrome.'
        -- Pete Bentley
Rasputin :: Jack of All Trades - Master of Nuns

В списке pgsql-admin по дате отправления:

Предыдущее
От: Pallav Kalva
Дата:
Сообщение: Re: Postgres crashed on invalid IP entry in pg_hba.conf
Следующее
От: thomas.revell@powerconv.alstom.com
Дата:
Сообщение: Determining current WAL