rolconfig and datconfig

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: rolconfig and datconfig
Date: 2025-02-13 08:11:03
Message-ID: CAA5-nLAmsJ9ySq7+tEn8tX0Udt-yqEC2D_Ls6nv+=Ts4s=J3dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

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?

Regards,

Fabrice

postgres [591176]=# \d pg_roles
View "pg_catalog.pg_roles"
┌────────────────┬──────────────────────────┬───────────┬──────────┬─────────┐
│ Column │ Type │ Collation │ Nullable │
Default │
├────────────────┼──────────────────────────┼───────────┼──────────┼─────────┤
│ rolname │ name │ │ │

│ rolsuper │ boolean │ │ │

│ rolinherit │ boolean │ │ │

│ rolcreaterole │ boolean │ │ │

│ rolcreatedb │ boolean │ │ │

│ rolcanlogin │ boolean │ │ │

│ rolreplication │ boolean │ │ │

│ rolconnlimit │ integer │ │ │

│ rolpassword │ text │ │ │

│ rolvaliduntil │ timestamp with time zone │ │ │

│ rolbypassrls │ boolean │ │ │

│ => rolconfig │ text[] │ C │ │

│ oid │ oid │ │ │

└────────────────┴──────────────────────────┴───────────┴──────────┴─────────┘

postgres [591176]=# \d pg_database
Table "pg_catalog.pg_database"
┌───────────────┬───────────┬───────────┬──────────┬─────────┐
│ Column │ Type │ Collation │ Nullable │ Default │
├───────────────┼───────────┼───────────┼──────────┼─────────┤
│ oid │ oid │ │ not null │ │
│ datname │ name │ │ not null │ │
│ datdba │ oid │ │ not null │ │
│ encoding │ integer │ │ not null │ │
│ datcollate │ name │ │ not null │ │
│ datctype │ name │ │ not null │ │
│ datistemplate │ boolean │ │ not null │ │
│ datallowconn │ boolean │ │ not null │ │
│ datconnlimit │ integer │ │ not null │ │
│ datlastsysoid │ oid │ │ not null │ │
│ datfrozenxid │ xid │ │ not null │ │
│ datminmxid │ xid │ │ not null │ │
│ dattablespace │ oid │ │ not null │ │
│ datacl │ aclitem[] │ │ │ │
└───────────────┴───────────┴───────────┴──────────┴─────────┘
Indexes:
"pg_database_oid_index" PRIMARY KEY, btree (oid), tablespace "pg_global"
"pg_database_datname_index" UNIQUE CONSTRAINT, btree (datname),
tablespace "pg_global"
Tablespace: "pg_global"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-02-13 10:45:44 Re: rolconfig and datconfig
Previous Message Jeff Janes 2025-02-13 00:01:54 Re: Table size is constantly growing and causing performance problems