glue_sql() for mixed and upper case names

Is there a way to use glue_sql() for mixed case and upper case names?

For example something like this

dbGetQuery(con, "SELECT \"mixedCase\" from my_table limit 5;")

from postgresql - Querying mixed case columns in SQL with R - Stack Overflow

but using glue or something similar?

Yes, use glue_sql() with the


syntax and the identifiers will be automatically quoted appropriately according to the connection type specified in .con.

Thanks for that Jim. I realised that glue_sql() wasn't the issue. I was creating a version of this:

I think the issue was in here:

        AND isc.table_name = {s[3]};",
      s = .,

But I have just decided to change the table names to lowercase.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.