PostgreSQL 9.5中有一个有用的函数,称为 aclexplode(),但我似乎找不到任何官方文档上。
There is a useful function in PostgreSQL 9.5 called aclexplode() but I can't seem to find any official documentation on it.
我应该避免使用它吗?
Should I avoid using it? Is it technically an unstable API?
推荐答案是的,您可以依靠它。最终在即将发布的PostgreSQL 12中记录了此功能(提交)。
Yes, you can rely on it. This function is finally documented in upcoming PostgreSQL 12 (commit).
aclexplode 返回 aclitem 数组作为一组行。输出列是授予者 oid ,受赠者 oid (< 0 PUBLIC ),以 text ( SELECT ,。)授予特权。 ..)以及prilivege是否可授予 boolean 。 makeaclitem 执行相反的操作。
aclexplode returns an aclitem array as a set rows. Output columns are grantor oid, grantee oid (0 for PUBLIC), granted privilege as text (SELECT, ...) and whether the prilivege is grantable as boolean. makeaclitem performs the inverse operation.
更多推荐
我可以依赖PostgreSQL中的aclexplode()函数吗?
发布评论