Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 113A89FBCAC
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Mar 2007 15:17:03 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 77445-01-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Mar 2007 15:16:40 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wr-out-0506.google.com (wr-out-0506.google.com
 [64.233.184.228])
	by postgresql.org (Postfix) with ESMTP id AF81B9FBCC0
	for <pgsql-sql@postgresql.org>; Thu, 29 Mar 2007 15:16:32 -0300 (ADT)
Received: by wr-out-0506.google.com with SMTP id 70so322398wra
	for <pgsql-sql@postgresql.org>; Thu, 29 Mar 2007 11:16:32 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=NuxqRTiM+uzFVh5//xosZ6s5DQg53QvilYx07az6o19QE7NfNZdzambt6ndqeZlXRrxFqs3VNPycdiPZxrOfhqwI6KvcnnKdgNm0bkPmojXFj7asz/CRVRYwE4Nfyu2zBW6+ApSi+/GHU31Tnxc9SqzvnaV7JL/a5QYHBJEFqTU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=L53liOhADMl3HWpczqoXKP5l7wCItVABailz2q5e4RKBlQ4mOajXmtAd+fw5Hp50/0r36iM6kZoAeUW1ihZSHqNcbMv//vLJ5h40byCCWnIeAMLv2s366aF/7RCkHLqnsQTUeGGLe9rffP/AADlWctR57XiEzeiLjDBHSxjECW0=
Received: by 10.100.47.6 with SMTP id u6mr686399anu.1175192191621;
	Thu, 29 Mar 2007 11:16:31 -0700 (PDT)
Received: by 10.100.197.13 with HTTP; Thu, 29 Mar 2007 11:16:31 -0700 (PDT)
Message-ID: <a97c77030703291116p2488c816v42858b658c92bf09@mail.gmail.com>
Date: Thu, 29 Mar 2007 23:46:31 +0530
From: "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
To: "ezequias@fastcon.com.br" <ezequias@fastcon.com.br>
Subject: Re: Empty Table
Cc: pgsql-sql@postgresql.org
In-Reply-To: <web-47683571@correio2.docasdoporto.com.br>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <web-47683571@correio2.docasdoporto.com.br>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/350
X-Sequence-Number: 27988

psql> TRUNCATE TABLE <tablename>;

if you have too many tables , generate the above commands
by using a query on tables information schema table.
hope it helps.

On 3/29/07, ezequias@fastcon.com.br <ezequias@fastcon.com.br> wrote:
> Hi list,
>
> I have many tables with many constraints and I would like to empty all my
> tables.
>
> There is any simple way to do it ?
>
> I have pgAdmin here but not psql.
>
> Any help would be glad.
>
> Regards
> Ezequias
>
>
> --
> Ezequias Rodrigues da Rocha
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>