diff options
| -rw-r--r-- | doc/src/sgml/func.sgml | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index d427d5026a3..927d72d14b3 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.234.4.2 2005/01/26 20:42:26 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.234.4.3 2005/01/28 23:13:26 tgl Exp $ PostgreSQL documentation --> @@ -8506,6 +8506,10 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </para> <indexterm zone="functions-info"> + <primary>format_type</primary> + </indexterm> + + <indexterm zone="functions-info"> <primary>pg_get_viewdef</primary> </indexterm> @@ -8555,6 +8559,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <tbody> <row> + <entry><literal><function>format_type</function>(<parameter>type_oid</parameter>, <parameter>typemod</>)</literal></entry> + <entry><type>text</type></entry> + <entry>get SQL name of a data type</entry> + </row> + <row> <entry><literal><function>pg_get_viewdef</function>(<parameter>view_name</parameter>)</literal></entry> <entry><type>text</type></entry> <entry>get <command>CREATE VIEW</> command for view (<emphasis>deprecated</emphasis>)</entry> @@ -8644,6 +8653,12 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </table> <para> + <function>format_type</function> returns the SQL name of a data type that + is identified by its type OID and possibly a type modifier. Pass NULL + for the type modifier if no specific modifier is known. + </para> + + <para> <function>pg_get_viewdef</function>, <function>pg_get_ruledef</function>, <function>pg_get_indexdef</function>, |