Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id E3DE09FC2FF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Mar 2007 16:43:15 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 62719-01-7 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 29 Mar 2007 16:43:04 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.247])
	by postgresql.org (Postfix) with ESMTP id 2079F9FC354
	for <pgsql-sql@postgresql.org>; Thu, 29 Mar 2007 16:34:45 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c24so270880ana
	for <pgsql-sql@postgresql.org>; Thu, 29 Mar 2007 12:34:44 -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=Wc6/sMGDMW1/YzLu+qdX3w+JCeETDN9isbFc1yr8OnE8wwvtstZXwym7qnBOr+vukWvY8VjluuLykg+JvG8jV8i6F7KqPoZ5Jkjk5mODLI/vkRShK9akCb4cT2ohhMQjG4wR1CPTvDwOsejSz8Rdy7WXib6mcQNvHblP071FsBw=
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=WXkoUMw3coOlBOPfSjtIj9LtxzLHHkgwd1rEA6Rr/nW3mVjc34jIlPJY5gXcxEjKs7lkmgCAzHoDdE1DezTWB8y2DOmS4K4tXz7Pc+Wj4rUjlp/XbKJoVTnqM0vpmmGnMYM8PkFuS7KBkABrmnOkHI6qzSvm6/R1vG5Z7JHPSzs=
Received: by 10.100.112.19 with SMTP id k19mr759889anc.1175196884006;
	Thu, 29 Mar 2007 12:34:44 -0700 (PDT)
Received: by 10.100.197.13 with HTTP; Thu, 29 Mar 2007 12:34:43 -0700 (PDT)
Message-ID: <a97c77030703291234w592c715ajc556feadba2fe2b3@mail.gmail.com>
Date: Fri, 30 Mar 2007 01:04:43 +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-47685764@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: <a97c77030703291116p2488c816v42858b658c92bf09@mail.gmail.com>
	<web-47685764@correio2.docasdoporto.com.br>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/352
X-Sequence-Number: 27990

I dont think i clearly understand your requirement.

Are you wanting to restore the "PLAIN" backup of a database
with a different database name ?

what do you mean "deleting information of current database ..."

I have not used pgAdmin as i prefer cmd line mostly.

eager to help,  (expect my next reply aft 6 hrs , i am abt to crash now).
hope someone else helps u in meantime.

regds
On 3/30/07, ezequias@fastcon.com.br <ezequias@fastcon.com.br> wrote:
> 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
>