title: PostgreSQL:How to insert values in an array into a table
body: <p>for example,</p>
  
  <p><kbd>myelems</kbd> is my table</p>
  
  <pre><code>create table myelems (id int,element text)
  </code></pre>
  
  <p>and if I have an <em>array</em> </p>
  
  <pre><code>ARRAY['A','B','C']
  </code></pre>
  
  <p>then how to insert the <em>values</em> in the above <em>array</em> into my table <em>myelems</em>?
  <br>i.e,</p>
  
  <pre><code> id|element 
  ---+-------
   1 |A
   2 |B
   3 |C
  </code></pre>