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