Re: Empty Table

[<ezequias(at)fastcon(dot)com(dot)br>]

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