title: kafka JDBC source connector not able to pick up postgress table
body: <p>i have a standalone kafka runing on windows and a JDBC source connector connected with postgress db which is available on my machine. when i try to run the connector it shows a warning that no tasks will be run because no tables were found. whereas if i connect the same connector with mysql db (which is also locally installed). it is able to pick up the tables and works fine. please note that i am using confluent's jdbc connector with default apache-kafka.</p>
  <p>below is the warning i get with postgress
  <a href="https://i.stack.imgur.com/8iLMF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8iLMF.png" alt="enter image description here" /></a></p>
  <p>here are the configurations of my jdbc source worker</p>
  <pre><code>name=postgress-to-topic
  connector.class=io.confluent.connect.jdbc.JdbcSourceConnector
  connection.url=jdbc:postgresql://localhost:5432/test-kafka
  connection.user=postgres
  connection.password=postgress
  topic.prefix=postgres-
  #mode=bulk
  mode=incrementing
  incrementing.column.name=id
  errors.log.enable=true
  errors.log.include.messages=true
  tasks.max=1
  poll.interval.ms =100
  schema.pattern=test-kafka
  #catalog.pattern=test-kafka
  table.whitelist=mytable
  #dialect.name=PostgreSqlDatabaseDialect
  key.converter=org.apache.kafka.connect.json.JsonConverter
  value.converter=org.apache.kafka.connect.json.JsonConverter
  key.converter.schemas.enable=false
  value.converter.schemas.enable=false
  topic.prefix=postgress-
  </code></pre>
  <p>these are mysql configs in the same file which are commented for now.</p>
  <pre><code>   #mysql configs
      #connection.user=root
      #connection.password=root
      #connection.url=jdbc:mysql://localhost:3306/test-kafka?useSSL=false
      #name=mysql-to-topic
      #topic.prefix=mysql2-
      #schema.pattern=test-kafka
      #table.whitelist=user-data-1
  </code></pre>
  <p>below is how my postgress db looks like</p>
  <p><a href="https://i.stack.imgur.com/vUggF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vUggF.png" alt="enter image description here" /></a></p>
  <p>and below is how my mysql db looks like (which is working fine)</p>
  <p><a href="https://i.stack.imgur.com/hHoZV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hHoZV.png" alt="enter image description here" /></a></p>
  <p>i don't have much experience with postgress and not able to understand why it's not able to pick up table in postgress.</p>