How can I import a JSON file into PostgreSQL?
<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>