Daniel Possenriede

Probably a better implementation and one that is closer to the current one: ```sql SELECT c.relname AS name FROM pg_class AS c JOIN pg_namespace AS n ON c.relnamespace = n.oid...

I submitted a PR for `dbListTables()` (#261), but now realise that this probably should extend to `dbExistsTable()` and `dbListFields()` as well?! Update: And also `dbListObjects()`. I assume that [`find_table()`](https://github.com/r-dbi/RPostgres/blob/5e295463e33a2d87a71471fea24522f9cf438904/R/tables.R#L272-L308), which...

I missed `dbUnquoteIdentifier()` at least ```r library(DBI) con

Not sure whether this question was directed at me, but FWIW, I am not aware of any, but I am not an expert. How is this relevant for RPostgres? (Because...

The suggested changes in the first post are now here: https://github.com/r-dbi/RPostgres/compare/master...dpprdan:fix/col_in_dbQuoteIdentifier (slightly updated for correct element order).

> I no longer really like the `Id()` interface. What's the alternative? Is there another way to make the `glue_sql()` example in the first post above work?

> If we open dbQuoteIdentifier(), the roundtrip Id -> quote -> unquote is guaranteed only for table objects – so be it. Agree. I’d say that this is already the...

👍 I'll look into it over the holidays.

The checks [fail here](https://github.com/r-dbi/DBItest/blob/1f338f13a2690b0c514c314c5db679482478f8d6/R/spec-sql-list-objects.R#L104-L111) With the current CRAN release and an empty database, this looks like this: ``` r library(RPostgres) con #> [[2]] #> "pg_catalog". (unquoted [[1]] #> schema =...

> The test can probably be fixed for tables if we write a table to the db and then test whether the quote-unquote roundtrip works for that (i.e. only for...