diff options
author | Bruce Momjian <bruce@momjian.us> | 2011-02-26 01:55:26 -0500 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2011-02-26 01:56:49 -0500 |
commit | 772dcfe7c0b3c678c8aef11de2bf8a52150a56f1 (patch) | |
tree | 6c0fd514a4014518a8a33cc7bdcf9d0ec1fdd3ea | |
parent | 000128bc7f591025d0c1ce539bb53c6ad00ab69c (diff) | |
download | postgresql-772dcfe7c0b3c678c8aef11de2bf8a52150a56f1.tar.gz postgresql-772dcfe7c0b3c678c8aef11de2bf8a52150a56f1.zip |
Document pg_options_to_table() (not previously documented)
-rw-r--r-- | doc/src/sgml/func.sgml | 15 |
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 |