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.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