从Greenplum中查询用户名

最新推荐文章于 2024-06-20 21:52:33 发布

原创最新推荐文章于 2024-06-20 21:52:33 发布 · 4.3k 阅读

0 ·

CC 4.0 BY-SA版权

数据库开发同时被 2 个专栏收录

93 篇文章

订阅专栏

Greenplum相关

35 篇文章

订阅专栏

本文介绍了如何使用SQL语句查询具有特定前缀的用户名及其属性，并通过CASE语句进行条件判断来获取用户的不同属性标识。

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
where u.usename like 'p_%'
ORDER BY 1;