Error with name that contains an uppercase letter

[Yusseiin]

Hi,
thanks for the node.
I have a problem when i am trying to reach a table with a uppercase letter.
I have a table named "Gant"

When i try to select from it i receive an error back:
"error: relation "public.gant" does not exist"

I think the problem is that the node is searching for "gant" and not for "Gant", if i rename the table from PostgreSQL in "gant" everything work.

Edit:
The same error is recurring with the Columns name

[Alkarex]

Hello,
PostgreSQL is case sensitive when it comes to table names, if they have been created in a case-sensitive way.
The behaviour is not due to this Node-RED node, which passes the query directly to the database.
To address a table name or column name that have uppercase letters, you need to use double quotes around them:

SELECT * FROM "Gant" LIMIT 2;

See https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

[Yusseiin]

It still has some problem.
I'am missing something?

[Alkarex]

Can you try the same request in pgAdmin and show the results?

[Yusseiin]

Actually i got the same error from pgAdmin

I have managed to get working escaping only the table and not public

Thanks for the help