Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

improve SQL autocompletion's understanding of schemas #3593

Closed
kevinushey opened this issue Oct 3, 2018 · 1 comment
Closed

improve SQL autocompletion's understanding of schemas #3593

kevinushey opened this issue Oct 3, 2018 · 1 comment
Assignees
Milestone

Comments

@kevinushey
Copy link
Contributor

@kevinushey kevinushey commented Oct 3, 2018

System details

RStudio Edition : Desktop
RStudio Version : v1.2.1015
OS Version      : macOS 10.14
R Version       : 3.5.1

Steps to reproduce the problem

Using this document:

```{r}
library(RPostgres)
conn <- dbConnect(RPostgres::Postgres())
dbWriteTable(conn, "mtcars", mtcars)
```

```{sql, connection=conn}
select mpg, cyl from public.mtcars
```

Describe the problem in detail

Fields are not autocompleted from the mtcars table.

Describe the behavior you expected

The SQL autocompletion system needs to better understand references to tables from schemas.

@kevinushey kevinushey self-assigned this Oct 3, 2018
@kevinushey kevinushey added this to the v1.2 milestone Oct 3, 2018
@kevinushey
Copy link
Contributor Author

@kevinushey kevinushey commented Oct 3, 2018

dbListObjects() will likely be helpful here, as it exposes information on the schemas available with a particular connection.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant