R with postgresql database

Question

I've been trying to query data from postgresql database (pgadmin) into R and analyse. Most of the queries work except when I try to write a condition specifically to filter out most of the rows. Please find the code below

dbGetQuery(con, 'select * from "db_name"."User" where "db_name"."User"."FirstName" = "Mani" ')

Error in result_create(conn@ptr, statement) : Failed to prepare query: ERROR: column "Mani" does not exist LINE 1: ...from "db_name"."User" where "db_name"."User"."FirstName" = "Mani" ^

this is the error I get, Why is it considering Mani as a column when it is just an element. Someone pls assist me

Tim Biegeleisen · Accepted Answer · 2019-06-25 11:08:09Z

4

String literals in Postgres (and most flavors of SQL) take single quotes. This, combined with a few other optimizations in your code leave us with this:

sql <- "select * from db_name.User u where u.FirstName = 'Mani'"
dbGetQuery(con, sql)

Note that introduced a table alias, for the User table, so that we don't have to repeat the fully qualified name in the WHERE clause.

answered Jun 25, 2019 at 11:08

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

R with postgresql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related