title: PostgreSQL - dump each table into a different file
body: <p>I need to extract SQL files from multiple tables of a PostgreSQL database. This is what I've come up with so far:</p>
  
  <pre><code>pg_dump -t 'thr_*' -s dbName -U userName &gt; /home/anik/psqlTest/db_dump.sql
  </code></pre>
  
  <p>However, as you see, all the tables that start with the prefix <code>thr</code> are being exported to a single unified file (<code>db_dump.sql</code>). I have almost 90 tables in total to extract SQL from, so it is a must that the data be stored into separate files. </p>
  
  <p>How can I do it? Thanks in advance. </p>