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"
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 |