I couldn't find the documentation. Attached patch adds one.

Probably this function should have been named pg_*. Too late.

--
Fabien.
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index edc9be92a6..0e5f8b914b 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -16398,6 +16398,12 @@ SET search_path TO <replaceable>schema</replaceable> 
<optional>, <replaceable>sc
      </thead>
 
      <tbody>
+      <row>
+       
<entry><literal><function>acldefault</function>(<parameter>type</parameter>,
+                                  <parameter>oid</parameter>)</literal></entry>
+       <entry><type>aclitem[]</type></entry>
+       <entry>default hardcoded access privileges for an object belonging to 
<parameter>oid</parameter></entry>
+      </row>
       <row>
        
<entry><literal><function>has_any_column_privilege</function>(<parameter>user</parameter>,
                                   <parameter>table</parameter>,
@@ -16605,6 +16611,9 @@ SET search_path TO <replaceable>schema</replaceable> 
<optional>, <replaceable>sc
     </tgroup>
    </table>
 
+   <indexterm>
+    <primary>acldefault</primary>
+   </indexterm>
    <indexterm>
     <primary>has_any_column_privilege</primary>
    </indexterm>
@@ -16648,6 +16657,27 @@ SET search_path TO <replaceable>schema</replaceable> 
<optional>, <replaceable>sc
     <primary>row_security_active</primary>
    </indexterm>
 
+   <para>
+    <function>acldefault</function> returns the hardcoded default access 
privileges
+    for an object of <parameter>type</parameter> belonging to role 
<parameter>oid</parameter>.
+    Type is a <type>CHAR</type>, use
+    'c' for <literal>COLUMN</literal>,
+    'r' for relation-like objects such as <literal>TABLE</literal> or 
<literal>VIEW</literal>,
+    's' for <literal>SEQUENCE</literal>,
+    'd' for <literal>DATABASE</literal>,
+    'f' for <literal>FUNCTION</literal> or <literal>PROCEDURE</literal>,
+    'l' for <literal>LANGUAGE</literal>,
+    'L' for <literal>LARGE OBJECT</literal>,
+    'n' for <literal>SCHEMA</literal>,
+    't' for <literal>TABLESPACE</literal>,
+    'F' for <literal>FOREIGN DATA WRAPPER</literal>,
+    'S' for <literal>FOREIGN SERVER</literal>,
+    'T' for <literal>TYPE</literal> or <literal>DOMAIN</literal>.
+    Default access permissions are described in
+    <xref linkend="sql-grant"/> and can be overwritten with
+    <xref linkend="sql-alterdefaultprivileges"/>.
+   </para>
+
    <para>
     <function>has_table_privilege</function> checks whether a user
     can access a table in a particular way.  The user can be

Reply via email to