Re: rolconfig and datconfig

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема Re: rolconfig and datconfig
Дата
Msg-id 202502131319.5cbc7row4hok@alvherre.pgsql
обсуждение исходный текст
Ответ на rolconfig and datconfig  (Fabrice Chapuis <fabrice636861@gmail.com>)
Список pgsql-admin
Hello

On 2025-Feb-13, Fabrice Chapuis wrote:

> il we need to consult the options for a specific role, we can find that
> information in the pg_roles table. But options for a database is not in
> pg_database, there is no field datconfig. Is there a reason for that?

Yeah, options are stored separately to support having options that vary
per user and per database.  See \drds, especially under psql -E.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"No renuncies a nada. No te aferres a nada."



В списке pgsql-admin по дате отправления: