title: PostgreSQL -- Clean way of extracting protobuf field via SQL
body: <p>I have been trying to figure out how to cleanly extract <i>some_value</i> from something that looks like this:</p>
  
  <pre><code>SELECT protobuff_text FROM table_name;
  &gt;&gt;
  resource_id {
     high_part: 10310138280989442894
     low_part: 12186277462739912197
  }
  ...
  }
  known_field_name: some_value
  mask {
    points {
  ...
  </code></pre>
  
  <p>It should be extracted without assuming anything about what happens before or after it besides the newline.  This is easy in MySQL... but I have been having a hard time figuring it out in postgres.</p>
  
  <p>Any PostgreSQL experts out there who can help me with this?</p>
  
  <p>P.S. The string that is inserted into the database is created via <code>com.google.protobuf.TextFormat.printToString(Message m)</code>.</p>