Postgres Pro
Downloads
Home   >   mailing lists

Re: truncate all tables? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: truncate all tables?
Date
Msg-id 08568E80-0A88-4EB8-A83C-307DADB1402F@myrealbox.com
Whole thread Raw
In response to Re: truncate all tables?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
On Jun 29, 2005, at 7:04 PM, Richard Huxton wrote:

> Zlatko Matić wrote:
>
>> How could I truncate, delete all content of all tables in one step ?
>>
>
> Something like this?
>
> pg_dump --schema-only mydb > mydb.schema.dump
> dropdb mydb
> psql -f mydb.schema.dump mydb

That's nice!

Michael Glaesemann
grzm myrealbox com

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: truncate all tables?
Next
From: Enrico Weigelt
Date:
Subject: Re: rule as on insert to view with multiple fk referencing the same table