title: Insert JSON into Postgres 9.5
body: <p>In <strong>Python 3.6</strong> I have a variable '<strong>data2</strong>' which contains a <strong>JSON</strong> that looks like this:</p>
  
  <pre><code>{
      'id': 4573457, 'account_id': 456, 'address': '15 Millers Rd, WA', 
      'category_id': 4565, 'description': None, 'is_anonymous': False, 
      'iso_created_at': '2017-11-21T14:08:54+11:00', 
      'location': {
          'latitude': -56.564848493, 'longitude': 345.5948493}, 
      'report_state_id': 45655, 'report_state_name': 'ALL PICKED', 
      'title': 'South', 'user_id': 44555, 'user_short_name': 'Todd G.', 
      'users_alerted_count': 0, 'users_opened_count': 6, 'shape_id': 56
  }
  </code></pre>
  
  <p>I want to write an insert statement to insert this data into a table I have already created in <strong>Postgres 9.5</strong>, the table has 3 columns - <em>channel, report_id and report_data</em> -</p>
  
  <p>I want to insert the 'account_id' from the JSON into the channel column, the 'id' into the report_id column and the rest of the JSON all into the report_data column.</p>
  
  <p>Can someone please tell me how I can do this?</p>