Re: autocompletion, any chance you can provide us with a reproducible example? For example, the following works with this connection:
```{r}
library(RPostgres)
conn <- dbConnect(RPostgres::Postgres())
dbWriteTable(conn, "mtcars", mtcars)
```
```{sql, connection=conn}
select mpg, cyl from mtcars
```
Is the notion of a Postgres 'catalog' unique compared to the traditional notion of a database? Is there a way I can bootstrap a database so I can try testing locally?