英文:
Table pg_statistic_ext_data is not accessible on Postgres (Amazon RDS)
问题
Table pg_statistic_ext_data 无法在 Amazon RDS Postgres 上访问，但需要了解数据库的扩展统计信息。
英文:
Table pg_statistic_ext_data can not be accessed on Amazon RDS Postgres, but is needed to understand the extended statistics of the database.
答案1
得分: 3
AWS支持的回复：
> 很遗憾，在Amazon RDS中没有提供对 pg_statistic_ext_data 的访问权限，不过 pg_stats_ext 是一个公开可读的视图，显示的只是当前用户可读表和列的信息。我建议您使用 pg_stats_ext，它还以更易读的格式输出信息。
>
> 视图 pg_stats_ext 提供对 pg_statistic_ext 和 pg_statistic_ext_data 目录中存储的信息的访问。该视图仅允许访问用户有读取权限的 pg_statistic_ext 和 pg_statistic_ext_data 的行，因此允许公开对此视图的读取访问是安全的。
>
> pg_stats_ext 还设计成以更易读的格式呈现信息，不过需要扩展其模式，以适应将来将新类型的扩展统计信息添加到 pg_statistic_ext 的情况，这是一个代价。
英文:
Answer from AWS Support:
> Unfortunately access to pg_statistic_ext_data is not provided in Amazon RDS, however pg_stats_ext is a publicly readable view on pg_statistic_ext_data that only exposes information about those tables and columns that are readable by the current user. I recommend you to use pg_stats_ext which also gives the output in a better readable format.
>
>The view pg_stats_ext provides access to the information stored in the pg_statistic_ext and pg_statistic_ext_data catalogs. This view allows access only to rows of pg_statistic_ext and pg_statistic_ext_data that correspond to tables the user has permission to read, and therefore it is safe to allow public read access to this view.
>
>pg_stats_ext is also designed to present the information in a more readable format than the underlying catalogs — at the cost that its schema must be extended whenever new types of extended statistics are added to pg_statistic_ext.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论