title: How do I query for a specific uuid in postgres?
body: <p>I am trying to query for a <code>uuid</code> in my <code>Postgres</code> db.  Here is my table schema:</p>
  
  <pre><code>        Column        |      Type       |              Modifiers              
  ----------------------+-----------------+-------------------------------------
   casefile_id          | uuid            | not null default uuid_generate_v1()
   org_id               | uuid            | 
   casefile_template_id | uuid            | 
   casefile_status      | casefile_status | 
  </code></pre>
  
  <p>I try to query with </p>
  
  <p><code>select * from casefile where casefile_id = 'e0da8698-32e6-11e7-a8de-985aeb8b64f';</code></p>
  
  <p>And get the error: </p>
  
  <p><code>ERROR:  invalid input syntax for uuid: "e0da8698-32e6-11e7-a8de-985aeb8b64f"</code></p>
  
  <p>I then look on SO and see this syntax:</p>
  
  <p><code>select * from casefile where casefile_id = ANY('{e0da8698-32e6-11e7-a8de-985aeb8b64f}');</code></p>
  
  <p>But still get the error:</p>
  
  <p><code>ERROR:  invalid input syntax for uuid: "e0da8698-32e6-11e7-a8de-985aeb8b64f"</code></p>
  
  <p>What am I missing?  How do I filter by <code>UUID</code>?  Why can't I query as I would any other primary key?</p>