Re: Empty Table

["Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>]

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(at)fastcon(dot)com(dot)br <ezequias(at)fastcon(dot)com(dot)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(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