title: Copy results from a PostgreSQL view in one DB to a table in another
body: <p>Complete PostgreSQL newb.</p>
  
  <p>I have 7-8 views worth of data in db1 that I need to copy into tables with a matching schemae (schemas?) in a different database, db2. The destination database may be the same instance of PostgreSQL, or one on a different box altogether. </p>
  
  <p>I know 2-3 different ways to accomplish this with the databases I'm familiar with, but I'm helpless on this one. Can someone suggest some basic strategies for me? </p>
  
  <p>In a perfect world, I'd prefer not to have to do anything that feels too ETL-ish - I'd rather do some sort of</p>
  
  <pre><code>SELECT FROM instance1.db1.viewname INTO instance2.db5.tablename
  </code></pre>
  
  <p>then dump data out of the view as text file and reload into the destination table. </p>
  
  <p>Since I don't know PostgreSQL, I don't really know what is within the realm of possibility, though.</p>