appsmithorg / appsmithorg/appsmith
[Feature] In a Postgres datasource, allow choosing a specific schema, and/or only display accessible tables
- Ngôn ngữ chính
- TypeScript
- Star
- 40.9k
- Fork
- 4.8k
- Merge trung bình
- 1 ngày 22 giờ
- Pull request đã merge (30 ngày)
- 45
Mô tả
## Summary
In a Postgres datasource, Instead of automatically querying pg_catalog for all tables/schemas, allow for a specific "schema" to be chosen, with the default being "public".
## Motivation
Currently, when choosing a Postgres database with many schemas besides "public", *all* the tables from *all* schemas are displayed in left panel, whether the database user has access to them or not. (This is a quirk of Postgres, that querying the pg_catalog table shows all schemas and tables whether privileges have been granted or not.)
## Additional Context
#There are two approaches, I've seen to this problem, ideally both may be implemented.
1. add a Schema field to the form where datasource is setup. Default is "public".
2. Metabase handles this beautifully, when adding a datasource, they query the privileges to only display tables that the database user has access to. It would be great if Appsmith could do this as well.
-------
Attached is a screenshot of the current result of adding a database with many schemas.

Hướng dẫn đóng góp
Đánh giá
Issue này chưa được đánh giá.