postgresql query user

发布时间：2020-12-13 16:44:41 所属栏目：百科来源：网络整理

导读：SELECT u.usename AS "User name" , u.usesysid AS "User ID" , CASE WHEN u.usesuper AND u.usecreatedb THEN CAST ( 'superuser,create database' AS pg_catalog.text) WHEN u.usesuper THEN CAST ( 'superuser' AS pg_catalog.text) WHEN u.usecreatedb T

SELECT u.usename AS "User name",  u.usesysid AS "User ID",  CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser,create
database' AS pg_catalog.text)
       WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text)
       WHEN u.usecreatedb THEN CAST('create database' AS
pg_catalog.text)
       ELSE CAST('' AS pg_catalog.text)
  END AS "Attributes"
FROM pg_catalog.pg_user u
ORDER BY 1;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!