Обсуждение: Suggest adding reference to pg_db_role_setting in chapter 18; expand catalog page
Suggest adding reference to pg_db_role_setting in chapter 18; expand catalog page
От
David Johnston
Дата:
Attached is a patch that provides a link to the catalog page for pg_db_role_settings from config.sgml. It also updates said catalog page to mention that the data from this catalog is available via psql \drds and also provides a query that will explode the setconfig column into its component parts - which \drds does not do.
I am imagine there might be a reason that the catalog pages do not reference the relevant psql meta-commands, or provide human-friendly examples, but I cannot think of what that might be and so here I provide.
David J.
Вложения
Re: Suggest adding reference to pg_db_role_setting in chapter 18; expand catalog page
От
Peter Eisentraut
Дата:
On 1/17/15 1:08 AM, David Johnston wrote: > Attached is a patch that provides a link to the catalog page for > pg_db_role_settings from config.sgml. It also updates said catalog page > to mention that the data from this catalog is available via psql \drds > and also provides a query that will explode the setconfig column into > its component parts - which \drds does not do. I don't like different parts of the system fighting each other about what is better. If the exploded view is better, then we should change \drds to show it. > I am imagine there might be a reason that the catalog pages do not > reference the relevant psql meta-commands, or provide human-friendly > examples, but I cannot think of what that might be and so here I provide. The catalog descriptions are in the "internals" part, so you'd only arrive there if you know what you are doing. If you want to learn about user-facing tools such as psql or pgadmin, they have their own documentation. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Suggest adding reference to pg_db_role_setting in chapter18; expand catalog page
От
Peter Eisentraut
Дата:
On 1/17/15 1:08 AM, David Johnston wrote: > Attached is a patch that provides a link to the catalog page for > pg_db_role_settings from config.sgml. It also updates said catalog page > to mention that the data from this catalog is available via psql \drds > and also provides a query that will explode the setconfig column into > its component parts - which \drds does not do. I don't like different parts of the system fighting each other about what is better. If the exploded view is better, then we should change \drds to show it. > I am imagine there might be a reason that the catalog pages do not > reference the relevant psql meta-commands, or provide human-friendly > examples, but I cannot think of what that might be and so here I provide. The catalog descriptions are in the "internals" part, so you'd only arrive there if you know what you are doing. If you want to learn about user-facing tools such as psql or pgadmin, they have their own documentation. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs