Re: [SQL] Truncate on pg_dump / pg_restore

[Bryce Nesbitt]

chris smith wrote: On Sat, Oct 25, 2008 at 5:32 PM, Bryce Nesbitt <[EMAIL PROTECTED]> wrote: 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'. Ooops, I was unclear.  I want most of the data!  There are just a few tables that I'd prefer be empty (truncated) in the restored database.  Most of the tables (and there are lots) are valuable. Could I  dump --schema-only, dump full, dump the toc, comment out the tables from the toc, restore the --schema-only, then restore the dump (minus the contents of the unwanted tables)?