Calling a table from Heroku Postgresql

[andresrcs]

This is not related to R but to postgresql's sql dialect, it is not case sensitive by default so you have to double quote column names if they contain upper case letters.

dbGetQuery(conh, 'SELECT "Open", "High", "Low" FROM apple WHERE "Open" > 70')

when working with Postgresql is better not to use upper case letters to keep things simple.

Edit: Now that I recall, I already told you this before

Trouble sending PostgreSQL query in R Studio

Hello R people, Please, I am trying to query a table that I created in PostgreSQL using the pgAdmin web interface. I created an empty table called "Actors", and attempted to write data into that table from R Studio. dbWriteTable(con,"Actors",value = voice,overwrite = TRUE) It appeared to be successful, because when I ran dbReadTable(conn = con,"Actors") I did get my populated table just as it is in the csv file. However, when I try to query that table, I get an error message. Here is my code: aquery <- dbSendQuery(conn = con,"SELECT movie,actor,character FROM Actors WHERE movie = Aladdin") Here is the error message: Error: Failed to prepare query: ERROR: relatio…