title: insert a BLOB via a sql script?
body: <p>I have an H2 database (<a href="http://www.h2database.com" rel="nofollow noreferrer" title="H2 database">http://www.h2database.com</a>) and I'd like to insert a file into a BLOB field via a plain simple sql script (to populate a test database for instance). I know how to do that via the code but I cannot find how to do the sql script itself.</p>
  <p>I tried to pass the path, i.e.</p>
  <pre><code>INSERT INTO mytable (id,name,file) VALUES(1,'file.xml',/my/local/path/file.xml);
  </code></pre>
  <p>but this fails.</p>
  <p>Within the code (java for instance), it's easy to create a File object and pass that in, but directly from a sql script, I'm stuck ...</p>
  <p>Any idea?</p>