title: Get data from the last insert query using postgres
body: <p>i know there is a way how i can get the whole data from my last insert, including the auto generated fields, like id, and default content. But the problem is: How can i do this?</p>
  
  <p>for eg:</p>
  
  <pre><code>INSERT INTO schema.table (col1,col2) VALUES ("rowdata1","rowdata2");
  </code></pre>
  
  <p>the table looks like this:</p>
  
  <pre><code>id, col1, col2, col3 (default='t')
  </code></pre>
  
  <p>so how can i get the value of id and col3?
  There's a keyword like RETURNING or so, but this throws an error :)</p>