title: How to check if a given column is a primary key or an index in sqlite3?
body: <p>I know that <code>PRAGMA table_info('table_name');</code> will describe my table and if the column <code>pk</code> is 1 then that column is the primary key of my table. <br>
  Similarly, if I write <code>PRAGMA index_list('table_name');</code> it will give me the name of the indexes on the table. <br>
  How do I check if a given column is a primary key of the table? Also I want to check if given an index_name, this index_name is an index of the table.</p>
  
  <p>Edit: <br>
  How can I do this in python?</p>