Daniel Possenriede

Definitely. I haven't checked, yet, but I guess that RMariaDB has the [same issue](https://github.com/r-dbi/RPostgres/pull/372#issuecomment-1003181377) with `dbListObjects()` as RPostgres has.

There are no `dbListTables()` tests, correct?

☹️ I can reproduce on a Postgres 9.6. Apparently, `relispartition` (as well as `p = partitioned table`) was added in v10 (pg_class docs [v10](https://www.postgresql.org/docs/10/catalog-pg-class.html) vs [v9.6](https://www.postgresql.org/docs/9.6/catalog-pg-class.html)). How do you want...

> Are materialized views contained in INFORMATION_SCHEMA.views ? No, they are not since they are a PostgreSQL-specific feature. For more info, see [this thread](https://www.postgresql.org/message-id/flat/CAH7T-ao6ece1mgCsCvsE04W59ZZJP9gGXVK97wkUzRV5gsDqQQ%40mail.gmail.com) on the psql-hackers list for a...

I am not familiar with Redshift, at all, and don't know how to test ATM. [DESCRIPTION](https://github.com/r-dbi/RPostgres/blob/12c3d3dc67f93cbafca24b5496d2fc1a9cf0f562/DESCRIPTION#L53) says `libpq >= 9.0`, BTW.

I found this: > The standard PostgreSQL catalog tables are accessible to Amazon Redshift users. For more information about PostgreSQL system catalogs, see [PostgreSQL system tables](https://www.postgresql.org/docs/8.0/static/catalogs.html#CATALOGS-OVERVIEW). This links to the...

Sounds good, I think! Just to make sure, you mean: | INFORMATION_SCHEMA | systems catalog | |-----------------|-----------------| | `dbListTable()` | `pqListTables()` | | `dbListFields()` | `pqListFields()` | | `dbExistsTable()` |...

Probably obvious, but we may need Redshift-specific functions as well, when a query relies on a Postgres function that [Redshift does not support](https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html), e.g. https://github.com/r-dbi/RPostgres/issues/211. (Plus unsupported PG [data types](https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-datatypes.html)...

I added new pq* versions of `dbListTables()`, `dbExistsTable()`, `dbListObjects()` and `dbListFields()`. They all query the system catalog (pg_class in particular) and are based on the same [underlying code](https://github.com/r-dbi/RPostgres/pull/261/files#diff-73a35922acced633ebf3fbf9b9a7c59f3b9ee52ddd3b0b67f4781216cf5850c1R46-R99). Remember that...

> I wonder if it's worth fixing here. Agree, the practical relevance is rather limited (though not entirely absent e.g. like in my reprex: creating a schema, then checking whether...