Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2023 12:34 AM
Hi @Retired_mod
I am able to query the pg_catalog database which has all lower case table names, so the connection is working.
I am unable to query the tables in my "public" schema, as they have capitalization in the table names.
If I query with no backticks or quotes, the lowercase and capitalized table name both give me this error.
- Error: [TABLE_OR_VIEW_NOT_FOUND] The table or view <foreign_catalog>.public.<table> cannot be found.
If I query with quotes, I get this error
- [PARSE_SYNTAX_ERROR] Syntax error at or near '"<table>"'.line 1, pos 39
If I query with backticks, I get this error
- [TABLE_OR_VIEW_NOT_FOUND] The table or view <foreign_catalog>.public.<table> cannot be found. Verify the spelling and correctness of the schema and catalog. If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog. To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS.; line 1, pos 14