aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2011-02-26 01:55:26 -0500
committerBruce Momjian <bruce@momjian.us>2011-02-26 01:56:49 -0500
commit772dcfe7c0b3c678c8aef11de2bf8a52150a56f1 (patch)
tree6c0fd514a4014518a8a33cc7bdcf9d0ec1fdd3ea
parent000128bc7f591025d0c1ce539bb53c6ad00ab69c (diff)
downloadpostgresql-772dcfe7c0b3c678c8aef11de2bf8a52150a56f1.tar.gz
postgresql-772dcfe7c0b3c678c8aef11de2bf8a52150a56f1.zip
Document pg_options_to_table() (not previously documented)
-rw-r--r--doc/src/sgml/func.sgml15
1 files changed, 15 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index c363949b7c5..edb77953cd2 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -13244,6 +13244,10 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
</indexterm>
<indexterm>
+ <primary>pg_options_to_table</primary>
+ </indexterm>
+
+ <indexterm>
<primary>pg_tablespace_databases</primary>
</indexterm>
@@ -13380,6 +13384,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
<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>
@@ -13475,6 +13484,12 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
</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