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 <br...@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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers