PostgreSQL field name and table name case-sensitive issues

When creating a table, the table name and field name must be all lowercase , and then the query will not be error-able, either full-capitalization or full-lowercase, or camel mode. As long as there are uppercase letters in the name, or all uppercase, the query must be cased correctly and wrapped in double quotation marks, otherwise it will be reported "XXX does not exist" error: "... does not exist"

Names such as views, stored procedures, indexes, foreign keys, and triggers are not tested, but the feeling should apply to all objects.

PS. After this processing, the camel-written attribute name in the Codefirst code in EntityFramework will be reported as a "nonexistent" error when queried, and it needs to be resolved manually by [Column ("lowercase name")].

PostgreSQL field name and table name case-sensitive issues