question Can Nifi insert data into uppercase table in postgesql ? in Support Questions

Can Nifi insert data into uppercase table in postgesql ?

mandychen — Wed, 26 Jul 2023 03:09:59 GMT

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.

Re: Can Nifi insert data into uppercase table in postgesql ?

SAMSAL — Wed, 26 Jul 2023 12:39:10 GMT

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

Re: Can Nifi insert data into uppercase table in postgesql ?

mandychen — Sun, 30 Jul 2023 23:45:24 GMT

I see, it work!

Thanks for your information