node.js - SQL query to PostgeSQL tables

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65927588/sql-query-to-postgesql-tables

Answer 1

This would be possible if the table were created using escaped column names . . . "postId" rather than postId.

I suspect that is the problem. The best solution is to recreate the table and not escape any identifiers, ever. Alternatively, you can use the escaped column name.