DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=GjYG/i0qFUl0B9LTvYO0odoia/3+pL/GmIi/0pxBHur6BSAD0APHCkPJ07fE6ydSBZ
	3EzQuqyvTB4KiMQHYTQjlFCd9l1HNBgTnbMLpvasPZM1a8VQKiEeNFlNehslM7tnipmP
	KJgdJhERE5bwU/9zhh5IdKjEmCJiemtb4oyKg=
Message-ID: <4DE3AD86.5020206@gmail.com>
Date: Mon, 30 May 2011 08:45:26 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20101027)
MIME-Version: 1.0
To: Surfing <onlinesurfing@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Function to total reset a schema
References: <4DE1F7DC.3080700@gmail.com>
In-Reply-To: <4DE1F7DC.3080700@gmail.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

I would hope you have readily at hand the ddl for the schema in 
question.  Then it's simply a matter of drop schema <name> cascade and 
re-run you ddl scripts.

Surfing wrote:
> Hi all,
> I need to write a function that totally empty a schema.
>
> So I have written a TRUNCATE statement for each table and set to 0 
> each sequence.
> Btw, it could be good to execute a vacuum statement on each table, but 
> from within the function this is not allowed.
>
> Is there a way to obtain the same result in another way (without using 
> the vacuum)?
>
> Thanks
>
>