title: Postgresql dump with data restriction
body: <p>I'm working on developing a fast way to make a clone of a database to test an application. My database has some specif tables that are quite big (+50GB), but the big majority of the tables only have a few MBs. On my current server, the dump + restore takes some hours. These bigs tables have date fields.</p>
  <p>With the context in mind, my question is: Is possible to use some type of restrictions on table rows to select the data that is being dumped? e.g. On table X only dump the rows that date is Y.</p>
  <p>If this is a possible show can I do it? if it's not possible what would be a good alternative?</p>