Truncate on pg_dump / pg_restore

From: Bryce Nesbitt <bryce2(at)obviously(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Truncate on pg_dump / pg_restore
Date: 2008-10-25 06:32:03
Message-ID: 4902BD63.2040704@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chris smith 2008-10-25 10:18:30 Re: Truncate on pg_dump / pg_restore
Previous Message David Garamond 2008-10-25 01:50:11 Re: grouping/clustering query