Re: Empty Table

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