title: Using pg_restore to create or overwrite tables
body: <p>I know this is a weird request, but for some hacky reasons I can't avoid, I'd like to be able to consistently sync a few tables from one database to another. I know I could write out the functionality myself in a script, but I figure <code>pg_dump</code> and <code>pg_restore</code> will apply a lot of optimizations to the process that I'm not aware of myself.</p>
  
  <p>What I'm wondering is if there's a way to have <code>pg_restore</code> overwrite the existing tables. Basically, in pseudo-code something like:</p>
  
  <pre><code>-- pseudo code
  begin;
  drop table to_restore;
  drop table to_restore2;
  drop table to_restore3;
  
  -- etc
  
  restore table to_restore;
  restore table to_restore2;
  restore table to_restore3;
  
  -- etc
  commit;
  </code></pre>
  
  <p>I'm also open to alternatives ways of doing this if this isn't so great.</p>