title: How to convert sqlilte3 database to tsv from python code?
body: <p>I am trying to get the tables inside sqlite3 database and save them into a tsv file.</p>
  
  <p>does pandas have a tool to do that?</p>
  
  <p>I know how to do it from sqlite:</p>
  
  <pre><code>sqlite&gt; .mode tabs
  sqlite&gt; .output test1.tsv
  sqlite&gt; Select * from &lt;table_name&gt;;
  </code></pre>
  
  <p>but how to do the samething in python environment?</p>