Case sensitive names?

[mitar]

I am trying to make a tool which would automatically quote all identifiers to make them case sensitive. I thought of parsing end deparsing (using this node module) but I am realizing that all identifiers in the parsed tree are already lowercased. Is there some way to not do that? So to get parse tree with original string values?

[lfittl]

Unfortunately thats not really feasible, since we depend on the Postgres parser logic - which will normalize identifiers if they are not escaped.

[mitar]

But you already patch it a bit, no? A simple change like this seems to work:

diff --git a/examples/simple.c b/examples/simple.c
index 1c513b1..5a27658 100644
--- a/examples/simple.c
+++ b/examples/simple.c
@@ -10,7 +10,7 @@
 size_t testCount = 7;
 const char* tests[] = {
   "SELECT 1",
-  "SELECT * FROM x WHERE z = 2",
+  "SELECT * FROM X WHERE Z = 2",
   "SELECT 5.41414",
   "SELECT $1",
   "SELECT ?",
diff --git a/src/postgres/src_backend_parser_scansup.c b/src/postgres/src_backend_parser_scansup.c
index 3925612..7bfc46a 100644
--- a/src/postgres/src_backend_parser_scansup.c
+++ b/src/postgres/src_backend_parser_scansup.c
@@ -88,11 +88,6 @@ downcase_identifier(const char *ident, int len, bool warn, bool truncate)
        for (i = 0; i < len; i++)
        {
                unsigned char ch = (unsigned char) ident[i];
-
-               if (ch >= 'A' && ch <= 'Z')
-                       ch += 'a' - 'A';
-               else if (enc_is_single_byte && IS_HIGHBIT_SET(ch) && isupper(ch))
-                       ch = tolower(ch);
                result[i] = (char) ch;
        }
        result[i] = '\0';

So exposing this somehow as a switch or something would be possible, or not?