title: How to use parameters with RPostgreSQL (to insert data)
body: <p>I'm trying to insert data into a pre-existing PostgreSQL table using <code>RPostgreSQL</code> and I can't figure out the syntax for SQL parameters (prepared statements).</p>
  
  <p>E.g. suppose I want to do the following</p>
  
  <p><code>insert into mytable (a,b,c) values ($1,$2,$3)</code></p>
  
  <p>How do I specify the parameters?  <code>dbSendQuery</code> doesn't seem to understand if you just put the parameters in the <code>...</code>.</p>
  
  <p>I've found <code>dbWriteTable</code> can be used to dump an entire table, but won't let you specify the columns (so no good for defaults etc.).  And anyway, I'll need to know this for other queries once I get the data in there (so I suppose this isn't really insert specific)!</p>
  
  <p>Sure I'm just missing something obvious...</p>