请问postgre的Access privileges中的＋什么意思？

我来答

yueli34

2024-06-13

postgresql

postgres=# \dn+

请问1.postgres=UC/postgres+中+什么意思？

2.第二行=UC/postgres是什么意思？

谢谢！

我来答

添加附件

问题补充

2条回答

默认

最新

小满未满、

没啥意思就是分隔符一样的存在就是换行了不代表所有数据展示完了
等价SQL

SELECT n.nspname AS "Name",
  pg_catalog.pg_get_userbyid(n.nspowner) AS "Owner",
  pg_catalog.array_to_string(n.nspacl, E'\n') AS "Access privileges",
  pg_catalog.obj_description(n.oid, 'pg_namespace') AS "Description"
FROM pg_catalog.pg_namespace n
WHERE n.nspname !~ '^pg_' AND n.nspname <> 'information_schema'
ORDER BY 1;
复制

你可以把这个E’\n’ 改成别的，比如说E’|’ 跑着玩玩

SELECT n.nspname AS "Name",
  pg_catalog.pg_get_userbyid(n.nspowner) AS "Owner",
  pg_catalog.array_to_string(n.nspacl, E'|') AS "Access privileges",
  pg_catalog.obj_description(n.oid, 'pg_namespace') AS "Description"
FROM pg_catalog.pg_namespace n
WHERE n.nspname !~ '^pg_' AND n.nspname <> 'information_schema'
ORDER BY 1;
复制