PostgresQL: Insert with key-value instead of two lists
<p>PostgresQL allows you to INSERT with two lists, one of field names, the other of values.</p>

<pre><code>INSERT INTO products (product_no, name, price) VALUES (1, 'Cheese', 9.99);
</code></pre>

<p>For long lists, it gets hard to figure out which list index you're on. Is there a way to insert by specifying the column name alongside the value, ie key-value pairs? Note: This is different than <code>hstore</code>.</p>

<p>ie.</p>

<pre><code>INSERT INTO products (product_no =&gt; 1, name =&gt; 'Cheese', price =&gt; 9.99);
</code></pre>