Skip site navigation (1) Skip section navigation (2)

Re: Empty Table

From: <ezequias(at)fastcon(dot)com(dot)br>
To: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>, "ezequias(at)fastcon(dot)com(dot)br" <ezequias(at)fastcon(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Empty Table
Date: 2007-03-29 18:50:26
Message-ID: web-47685764@correio2.docasdoporto.com.br (view raw or flat)
Thread:
Lists: pgsql-sql
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(dot)rajesh(at)gmail(dot)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(at)fastcon(dot)com(dot)br <ezequias(at)fastcon(dot)com(dot)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(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly

--
Ezequias Rodrigues da Rocha

In response to

Responses

pgsql-sql by date

Next:From: Rajesh Kumar MallahDate: 2007-03-29 19:34:43
Subject: Re: Empty Table
Previous:From: ezequiasDate: 2007-03-29 18:25:01
Subject: Empty Table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group