Re: Drop all databases objects except the database

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: Evandro <evandro(at)horizontenet(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Drop all databases objects except the database
Date: 2002-03-15 17:35:51
Message-ID: 3C9230F7.1070407@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Evandro wrote:

>HorizontenetHi Everyone,
>
> Does anyone know about a script or function to drop all databases
>objects except the database? ( to empty a database)
>

If you really want to drop ALL the objects, would it not be the same as
dropping the database and creating a new one?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2002-03-15 17:58:01 Re: Archives / News gateway
Previous Message Jan Wieck 2002-03-15 17:31:42 Re: Drop all databases objects except the database