title: How can I import a JSON file into PostgreSQL?
body: <p>For example I have a file <code>customers.json</code> which is an array of objects (strictly formed) and it's pretty plain (without nested objects) like this (what is important: it's already include ids):</p>
  
  <pre><code>[
    {
      "id": 23635,
      "name": "Jerry Green",
      "comment": "Imported from facebook."
    },
    {
      "id": 23636,
      "name": "John Wayne",
      "comment": "Imported from facebook."
    }
  ]
  </code></pre>
  
  <p>And I want to import them all into my postgres db into a table <code>customers</code>.</p>
  
  <p>I found some pretty difficult ways when I should import it as json-typed column to a table like <code>imported_json</code> and column named <code>data</code> with objects listed there, then to use sql to get these values and insert it into a real table.</p>
  
  <p>But is there a simple way of importing json to postgres with no touching of sql?</p>