@@ -2522,16 +2522,19 @@ listDbRoleSettings(const char *pattern, const char *pattern2)
2522
2522
{
2523
2523
bool havewhere ;
2524
2524
2525
- printfPQExpBuffer (& buf ,"SELECT rolname ASrole , datname ASdatabase ,\n"
2526
- "pg_catalog.array_to_string(setconfig, E'\\n') ASsettings \n"
2525
+ printfPQExpBuffer (& buf ,"SELECT rolname AS\"%s\" , datname AS\"%s\" ,\n"
2526
+ "pg_catalog.array_to_string(setconfig, E'\\n') AS\"%s\" \n"
2527
2527
"FROM pg_db_role_setting AS s\n"
2528
2528
"LEFT JOIN pg_database ON pg_database.oid = setdatabase\n"
2529
- "LEFT JOIN pg_roles ON pg_roles.oid = setrole\n" );
2529
+ "LEFT JOIN pg_roles ON pg_roles.oid = setrole\n" ,
2530
+ gettext_noop ("Role" ),
2531
+ gettext_noop ("Database" ),
2532
+ gettext_noop ("Settings" ));
2530
2533
havewhere = processSQLNamePattern (pset .db ,& buf ,pattern , false, false,
2531
2534
NULL ,"pg_roles.rolname" ,NULL ,NULL );
2532
2535
processSQLNamePattern (pset .db ,& buf ,pattern2 ,havewhere , false,
2533
2536
NULL ,"pg_database.datname" ,NULL ,NULL );
2534
- appendPQExpBufferStr (& buf ,"ORDER BYrole, database ;" );
2537
+ appendPQExpBufferStr (& buf ,"ORDER BY1, 2 ;" );
2535
2538
}
2536
2539
else
2537
2540
{