Suggest adding reference to pg_db_role_setting in chapter 18; expand catalog page
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.
Attachments:
config_db_role_update.difftext/plain; charset=US-ASCII; name=config_db_role_update.diffDownload+37-0
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