title: Load Json from http into postgres via python
body: <p>I have a link which consist of json data as below:</p>
  
  <p><a href="http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94182.json" rel="nofollow noreferrer">http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94182.json</a></p>
  
  <p>Sample Data from link :</p>
  
  <pre><code>"header": [
          {
              "refresh_message": "Issued at 12:02 pm EST Thursday  1 March 2018",
              "ID": "IDQ60801",
              "main_ID": "IDQ60800",
              "name": "Coconut Island",
              "state_time_zone": "QLD",
              "time_zone": "EST",
              "product_name": "Weather Observations",
              "state": "Queensland"
          }
      ],
  </code></pre>
  
  <p>How can I load the above data into postgres table via python? Should I load it into a dataframe first before loading it into postgres? I'm new to dataframe and pandas so would like to seek your help on it. </p>
  
  <p>My expected table in postgres would be something like below:</p>
  
  <pre><code>ID      | main_id|     name     | state_timezone | time_zone |   product_name     |     state
  IDQ60801|IDQ60800|Coconut Island|       QLD      |    EST    |Weather Observations| Queensland
  </code></pre>
  
  <p>Thanks for your help in advance</p>