This topic describes the syntax of the USER_DISPLAY_NAME function in Hologres.


user_display_name: maps a Hologres username to the corresponding Alibaba Cloud account or Resource Access Management (RAM) user.


SELECT user_diplay_name (user_name)


  1. user_name: the name of a Hologres user. Set this parameter to the ID of an Alibaba Cloud account, such as 13532241323xxx, or the UID of a RAM user prefixed with p4_, such as p4_23402030200xxx.
  2. The return value indicates the corresponding Alibaba Cloud account in the format of, or the corresponding RAM user in the format of RAM$mainaccount:subuser or RAM$public.


SELECT user_display_name ('13532241323xxx');
SELECT rolname, user_display_name(rolname) FROM pg_roles;