Re: rolconfig and datconfig - Mailing list pgsql-admin

From Álvaro Herrera
Subject Re: rolconfig and datconfig
Date
Msg-id 202502131319.5cbc7row4hok@alvherre.pgsql
Whole thread Raw
In response to rolconfig and datconfig  (Fabrice Chapuis <fabrice636861@gmail.com>)
List 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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: rolconfig and datconfig
Next
From: Dutch Glory
Date:
Subject: connection to server at "localhost" (::1), port 5432 failed: FATAL: Ident authentication failed for user "postgres"