diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-02-13 10:34:04 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-02-13 15:13:44 -0500 |
| commit | 7a32ac8a66903de8c352735f2a26f610f5e47090 (patch) | |
| tree | 0f85c4d3558b5634d4f58786eedf21df3a65bbe5 /doc/src | |
| parent | 7cd56f218d0f8953999b944bc558cd6684b15cdc (diff) | |
Add procedure support to pg_get_functiondef
This also makes procedures work in psql's \ef and \sf commands.
Reported-by: Pavel Stehule <pavel.stehule@gmail.com>
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 10 |
2 files changed, 10 insertions, 8 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 640ff09a7b9..4be31b082a8 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -17008,22 +17008,22 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <row> <entry><literal><function>pg_get_functiondef(<parameter>func_oid</parameter>)</function></literal></entry> <entry><type>text</type></entry> - <entry>get definition of a function</entry> + <entry>get definition of a function or procedure</entry> </row> <row> <entry><literal><function>pg_get_function_arguments(<parameter>func_oid</parameter>)</function></literal></entry> <entry><type>text</type></entry> - <entry>get argument list of function's definition (with default values)</entry> + <entry>get argument list of function's or procedure's definition (with default values)</entry> </row> <row> <entry><literal><function>pg_get_function_identity_arguments(<parameter>func_oid</parameter>)</function></literal></entry> <entry><type>text</type></entry> - <entry>get argument list to identify a function (without default values)</entry> + <entry>get argument list to identify a function or procedure (without default values)</entry> </row> <row> <entry><literal><function>pg_get_function_result(<parameter>func_oid</parameter>)</function></literal></entry> <entry><type>text</type></entry> - <entry>get <literal>RETURNS</literal> clause for function</entry> + <entry>get <literal>RETURNS</literal> clause for function (returns null for a procedure)</entry> </row> <row> <entry><literal><function>pg_get_indexdef(<parameter>index_oid</parameter>)</function></literal></entry> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 6f9b30b673c..8bd9b9387ec 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1815,8 +1815,9 @@ Tue Oct 26 21:40:57 CEST 1999 <listitem> <para> - This command fetches and edits the definition of the named function, - in the form of a <command>CREATE OR REPLACE FUNCTION</command> command. + This command fetches and edits the definition of the named function or procedure, + in the form of a <command>CREATE OR REPLACE FUNCTION</command> or + <command>CREATE OR REPLACE PROCEDURE</command> command. Editing is done in the same way as for <literal>\edit</literal>. After the editor exits, the updated command waits in the query buffer; type semicolon or <literal>\g</literal> to send it, or <literal>\r</literal> @@ -2970,8 +2971,9 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput> <listitem> <para> - This command fetches and shows the definition of the named function, - in the form of a <command>CREATE OR REPLACE FUNCTION</command> command. + This command fetches and shows the definition of the named function or procedure, + in the form of a <command>CREATE OR REPLACE FUNCTION</command> or + <command>CREATE OR REPLACE PROCEDURE</command> command. The definition is printed to the current query output channel, as set by <command>\o</command>. </para> |