# Logstash filter to extract string from Json in postgresql table

**URL:** <https://discuss.elastic.co/t/logstash-filter-to-extract-string-from-json-in-postgresql-table/141252>\
**Category:** Logstash\
**Created:** [July 23, 2018, 8:44pm UTC](https://discuss.elastic.co/t/logstash-filter-to-extract-string-from-json-in-postgresql-table/141252 "2018-07-23T20:44:34Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [July 24, 2018, 4:19pm UTC](https://discuss.elastic.co/t/logstash-filter-to-extract-string-from-json-in-postgresql-table/141252/6 "2018-07-24T16:19:12Z")

</div>

> [@Badger](#):
>
> I would ask a new question about Java::OrgLogstash::MissingConverterException

As I said, I would ask a new question about Java::OrgLogstash::MissingConverterException. You need to get the input working before you worry about the filter.

A PGobject is used to represent an unknown type, so the input does not know what to do with it. It's probably related to the fact that the column contains JSON. Perhaps you need to CAST the column (because you want a string to input to the json filter). I don't know. I don't use the jdbc input.

---

_[View the full topic](https://discuss.elastic.co/t/logstash-filter-to-extract-string-from-json-in-postgresql-table/141252)._