Re: Empty Table

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

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