postgresql query user

概述SELECT u.usename AS "User name", u.usesysid AS "User ID", CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, createdatabase' AS pg_catalog.text) WHEN u.usesuper THEN CAST('superu

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

总结

以上是内存溢出为你收集整理的postgresql query user全部内容，希望文章能够帮你解决postgresql query user所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。