Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: truncate all tables?
Date
Msg-id 42C27249.10800@archonet.com
Whole thread Raw
In response to truncate all tables?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
Responses Re: truncate all tables?
List pgsql-general
Tree view 
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

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: truncate all tables?
Next
From: Michael Glaesemann
Date:
Subject: Re: truncate all tables?