title: What's an easy way to populate a database through an sql query from a single entry?
body: <p>We're looking to populate a number of tables for testing. The data can all be the same except for a timestamp column. Other columns in the row contain complicated data, like objects in xml format and other messy stuff, so we don't want to have to remake it. <em>What would be an easy way to expand a single entry to thousands, by incrementing a timestamp by a constant interval, through a sql query.</em></p>
  
  <p>Our current idea (in a C-ish pseudocode) is to:</p>
  
  <pre><code>Get the latest (likely only) row and store it in a variable "thisRow"
  While(thisRow-&gt;time &lt; endTime)
  {
  Increment thisRow-&gt;time by a constant variable
  Insert thisRow
  }
  </code></pre>
  
  <p>We are using postgres</p>