title: escaping of double quote with text type column at postgresql and json parsing via jackson
body: <p><BR>
  I have the following table defined at postgresql: <BR></p>
  
  <pre><code>        Column      |          Type          | Modifiers 
  -----------------+------------------------+-----------
   id              | uuid                   | not null
   entity_snapshot | text                   | 
  Indexes:
      "pk_id" PRIMARY KEY, btree (id)
  </code></pre>
  
  <p>I would like to store the following JSon string:</p>
  
  <pre><code>[ "org.test.MyUniqueId", {:   "uuid" : "f4b40050-9716-4346-bf84-8325fadd9876": } ]
  </code></pre>
  
  <p>for some testing, instead of doing this using Jackson, I try to type an SQL manually, and here is my problem - I can't seem to get ti right. <BR>
  My current attempt is: <BR></p>
  
  <pre><code>insert into my_table(id,entity_snapshot) values ('d11d944e-6e78-11e1-aae1-52540015fc3f','[ \"org.test.MyUniqueId\", {:   \"uuid\" : \"f4b40050-9716-4346-bf84-8325fadd9876\": } ]');
  </code></pre>
  
  <p>Procuedure a record that looks like what I need when I select from the table, but when I try to use Jackson to parse it I get an error -</p>
  
  <pre><code>org.apache.commons.lang.SerializationException: org.codehaus.jackson.JsonParseException: Unexpected character (':' (code 58)): was expecting double-quote to start field name
  </code></pre>
  
  <p>Needless to say that if the same record is inserted via my java code , I can get it parsed and when it comes to looking at the record with human eyes, it looks the same to me. <BR>
  Can you tell me where I am wrong in my SQL insert statement?</p>