Calling a table from a Postresql Schema


I am trying to connect to a postresql data base with different schema. (in this example gas_feeder)
When i Write dplyr syntax it does not work ..
pricing_tbl <- dbReadTable(conOvc, "gas_feeder.pce_list") .

It only work with sql one
dbGetQuery(conOvc, "SELECT * FROM gas_feeder.pce_list")


Hi @jumix

Instead of dbReadTable try tbl (from dplyr)

Hope it help

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