On Sat, Oct 25, 2008 at 5:32 PM, Bryce Nesbitt <bryce2(at)obviously(dot)com> wrote:
> 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.
Do a schema-only dump.
pg_dump --help says use '-s' or '--schema-only'.
Postgresql & php tutorials
In response to
pgsql-sql by date
|Next:||From: Bryce Nesbitt||Date: 2008-10-25 15:23:46|
|Subject: Re: Truncate on pg_dump / pg_restore|
|Previous:||From: Bryce Nesbitt||Date: 2008-10-25 06:32:03|
|Subject: Truncate on pg_dump / pg_restore|