Does JDBC Multitable Consumer support table name with capital words?

asked 2019-11-12 03:28:06 -0600

Meihong gravatar image

My postgres database has all table named with mixed capital and small words. In "JDBC" section in JDBC Multitable Consumer, seems it cannot recognise these kind of table names. I have tried to double quote the schema, but it doesn't work. This problem doesn't happen using JDBC query consumer or CDC client.

edit retag flag offensive close merge delete

Comments

Are you referring to "Table Name Pattern" on "Tables" tab? I don't see where you'd specify table names on "JDBC" tab.

iamontheinet gravatar imageiamontheinet ( 2019-11-12 10:01:03 -0600 )edit

Sorry for confusion. You are right. For example, I use schema: public, table: Order. I tried to put double quote/single quote on table name, also tried to put double quote on schema name. But non of the combinations work. Can I know what is the correct format? I'm using Postgres server.

Meihong gravatar imageMeihong ( 2019-11-12 21:06:55 -0600 )edit