title: restore single table dump from a sql file
body: <p>I have full dump of sql file like <code>dump_full.sql</code> of size <code>1.3GB</code></p>
  
  <p>And it has some tables like</p>
  
  <pre><code>dancing_core_spice
  dancing_sea_beast
  
  forde_clear_one
  forde_super_now
  </code></pre>
  
  <p>Now what i want is need to restore/fetch/dump <code>only data</code> of these tables from <code>dump_full.sql</code>file</p>
  
  <pre><code>psql -U postgres --table=dancing_core_spice dump_full.sql &gt; dancing_core_spice.sql
  </code></pre>
  
  <p>i tried the above command but it is not working</p>
  
  <p>So can anyone please let me know how to take the dump of only single table from the sql file(full dump)</p>