| From: | Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Fabrice Chapuis <fabrice636861(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: rolconfig and datconfig |
| Date: | 2025-02-13 13:19:38 |
| Message-ID: | 202502131319.5cbc7row4hok@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dutch Glory | 2025-02-13 14:46:59 | connection to server at "localhost" (::1), port 5432 failed: FATAL: Ident authentication failed for user "postgres" |
| Previous Message | Laurenz Albe | 2025-02-13 10:45:44 | Re: rolconfig and datconfig |