Can Nifi insert data into uppercase table in postgesql ?

[#1]

Hi Team,
I create a dataflow try to insert data into uppercase table in postgesql.

But it does not work.

Appreciate any help on this issue, I am new to Nifi.

Here are my setting for QueryDatabaseTable and PutDatabaseRecord

The error message show

org.apache.nifi.processors.standard.db.TableNotFoundException: Table "ACPMA" not found, ensure the Catalog, Schema, and/or Table Names match those in the database exactly

Here is a uppercase table ACPMA in postgesql.

[#2 · Accepted solution]

Hi @mandychen ,

Have you tried removing the double quotes  from "ACPMA" in the Table Name property of the PutDatabaseRecord? I dont think you need it there.

If that helps please accept solution.

Thanks

[#3]

I see, it work!

Thanks for your information