Postgres Pro
Downloads
Home   >   mailing lists

Truncate on pg_dump / pg_restore - Mailing list pgsql-sql

From Bryce Nesbitt
Subject Truncate on pg_dump / pg_restore
Date
Msg-id 4902BD63.2040704@obviously.com
Whole thread Raw
Responses Re: Truncate on pg_dump / pg_restore  ("chris smith" <dmagick@gmail.com>)
List pgsql-sql
Tree view 
Dear Postgres Gurus;

Is there a way to truncate a table, at pg_dump time?

I'm aware of various ways to exclude a table from a dump (>= 8.2), or to
selectively pg_restore.  What I'm seeking here is different.  I've got
tables with pretty disposable data... meaning I want to drop the data...
but restore empty indexed tables at pg_restore time.

Doable?

pgsql-sql by date:

Previous
From: "David Garamond"
Date:
Subject: Re: grouping/clustering query
Next
From: "chris smith"
Date:
Subject: Re: Truncate on pg_dump / pg_restore