DatabaseMetaData#getTables not return tables of specified database name but connected database about pgjdbc

[davecramer]

@loserwang1024 a catalog in postgres is not a database, it is a schema.

[loserwang1024]

@davecramer , thanks for your answer.
ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String types[]) throws SQLException;
Is that mean params catalog and schemaPattern all represent schema?

[davecramer]

No catalog does nothing since we have no way to support it.

[pip25]

This behavior still looks very much like a bug to me compared to what's described in the JDBC API. If the getTables method receives a catalog name it cannot support (which is basically anything other than the current catalog name or null), it should report an error, not simply ignore the parameter and return invalid values.

[davecramer]

This behavior still looks very much like a bug to me compared to what's described in the JDBC API. If the getTables method receives a catalog name it cannot support (which is basically anything other than the current catalog name or null), it should report an error, not simply ignore the parameter and return invalid values.

we sort of punted here. I can support this position.