Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 3C3E79FBEE0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Mar 2007 15:35:31 -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 84091-01-4 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Mar 2007 15:35:06 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from correio2.docasdoporto.com.br
	(22.144.199.200.docasdoporto.com.br [200.199.144.22])
	by postgresql.org (Postfix) with ESMTP id CEFEE9FBEA3
	for <pgsql-sql@postgresql.org>; Thu, 29 Mar 2007 15:32:31 -0300 (ADT)
Received: from [201.32.161.79] (account ezequias@fastcon.com.br)
	by correio2.docasdoporto.com.br (CommuniGate Pro WebUser 4.1.8)
	with HTTP id 47685764; Thu, 29 Mar 2007 15:50:26 -0300
From: <ezequias@fastcon.com.br>
Subject: Re: Empty Table
To: "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>,
	"ezequias@fastcon.com.br" <ezequias@fastcon.com.br>
Cc: pgsql-sql@postgresql.org
X-Mailer: CommuniGate Pro WebUser Interface v.4.1.8
Date: Thu, 29 Mar 2007 15:50:26 -0300
Message-ID: <web-47685764@correio2.docasdoporto.com.br>
In-Reply-To: <a97c77030703291116p2488c816v42858b658c92bf09@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"; format="flowed"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/351
X-Sequence-Number: 27989

Thank you all for a so fast reply.

I did a backup PLAIN with pgAdmin and I had to delete the information of the 
current database (the database I used to make the backup).

I think that's why pgAdmin does not work with plain backups on Restore.

What does occurs with the information schema when I restore from one database 
with a name to other with another name ?

Regards
Ezequias



Em Thu, 29 Mar 2007 23:46:31 +0530
  "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> escreveu:
>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
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

--
Ezequias Rodrigues da Rocha