chris smith wrote:
On Sat, Oct 25, 2008 at 5:32 PM, Bryce Nesbitt <bryce2@obviously.com> 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)?