Josh Berkus wrote:
>
> > Right now pg_options_to_table() is not documented. Should it be?
>
> Yes, I think so.
Done, with the attached, applied patch.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 736eb67..c620142 100644
*** a/doc/src/sgml/func.sgml
--- b/doc/src/sgml/func.sgml
*************** SELECT pg_type_is_visible('myschema.widg
*** 13244,13249 ****
--- 13244,13253 ----
</indexterm>
<indexterm>
+ <primary>pg_options_to_table</primary>
+ </indexterm>
+
+ <indexterm>
<primary>pg_tablespace_databases</primary>
</indexterm>
*************** SELECT pg_type_is_visible('myschema.widg
*** 13380,13385 ****
--- 13384,13394 ----
<entry>get underlying <command>SELECT</command> command for view</entry>
</row>
<row>
+ <entry><literal><function>pg_options_to_table(<parameter>reloptions</parameter>)</function></literal></entry>
+ <entry><type>name, option</type></entry>
+ <entry>get the set of option name/value pairs from <structname>pg_class</>.<structfield>reloptions</></entry>
+ </row>
+ <row>
<entry><literal><function>pg_tablespace_databases(<parameter>tablespace_oid</parameter>)</function></literal></entry>
<entry><type>setof oid</type></entry>
<entry>get the set of database OIDs that have objects in the tablespace</entry>
*************** SELECT pg_type_is_visible('myschema.widg
*** 13475,13480 ****
--- 13484,13495 ----
</para>
<para>
+ <function>pg_options_to_table</function> returns the set of option
+ name/value pairs when passed
+ <structname>pg_class</>.<structfield>reloptions</>.
+ </para>
+
+ <para>
<function>pg_tablespace_databases</function> allows a tablespace to be
examined. It returns the set of OIDs of databases that have objects stored
in the tablespace. If this function returns any rows, the tablespace is not