diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 48cb4f6c2b6..d3529f560e3 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.437 2008/05/19 18:08:15 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.438 2008/07/03 20:58:46 tgl Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -11485,6 +11485,10 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </indexterm> <indexterm> + <primary>pg_get_keywords</primary> + </indexterm> + + <indexterm> <primary>pg_get_viewdef</primary> </indexterm> @@ -11539,6 +11543,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <entry>get SQL name of a data type</entry> </row> <row> + <entry><literal><function>pg_get_keywords</function>()</literal></entry> + <entry><type>setof record</type></entry> + <entry>get list of SQL keywords and their categories</entry> + </row> + <row> <entry><literal><function>pg_get_constraintdef</function>(<parameter>constraint_oid</parameter>)</literal></entry> <entry><type>text</type></entry> <entry>get definition of a constraint</entry> @@ -11634,6 +11643,16 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </para> <para> + <function>pg_get_keywords</function> returns a set of records describing + the SQL keywords recognized by the server. The <structfield>word</> column + contains the keyword. The <structfield>catcode</> column contains a + category code: <literal>U</> for unreserved, <literal>C</> for column name, + <literal>T</> for type or function name, or <literal>R</> for reserved. + The <structfield>catdesc</> column contains a possibly-localized string + describing the category. + </para> + + <para> <function>pg_get_constraintdef</function>, <function>pg_get_indexdef</function>, <function>pg_get_ruledef</function>, and <function>pg_get_triggerdef</function>, respectively reconstruct the |