Re: how to edit a function from psql?

What version of postgres are you using? In postgresql-7.4.6, I get an
empty query buffer when I try what you describe here.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Nov 4, 2004, at 5:23 PM, Karim Nassar wrote:

> Here is what I get:
>
> orfs=# \df+ get_datasets
>
> List of functions
> Result data type | Schema | Name |
> Argument
> data types | Owner | Language
> | Source
> code
> | Description
> ------------------+--------------+--------------
> +-------------------------------------------------+-------+----------
> +----------------------------------------------------------------------
> -----------------------------------------------------------------------
> -----------------------------------------------------------------------
> -----------------------------------------------------------------------
> ------------------------------------+-------------
> refcursor | weather_data | get_datasets | refcursor, character
> varying, character varying | kan4 | plpgsql |
> DECLARE
> _person_ ALIAS FOR $2;
> _where_ ALIAS FOR $3;
> selectstring text;
>
> BEGIN
> selectstring := get_datasets_selstr(_person_, _where_);
> -- RAISE NOTICE '%', selectstring;
> OPEN $1 FOR EXECUTE selectstring;
> RETURN $1;
> END;
> |
> (1 row)
>
> orfs=# \e
> CREATE FUNCTION
>
> When I issue \e, the editor window pops up, apparently with the
> contents
> of the query buffer. When I exit the editor, the function definition is
> applied to create this function (the one in the buffer).
>
> orfs=# \?
> <snip>
> Query Buffer
> \e [FILE] edit the query buffer (or file) with external editor
> \g [FILE] send query buffer to server (and results to file or
> |pipe)
> \p show the contents of the query buffer
> \r reset (clear) the query buffer
> \s [FILE] display history or save it to file
> \w [FILE] write query buffer to file
> <snip>
>
> How did that function definition get in the query buffer? Seems that it
> sure would be nice to fill it \df+...
>
> \<.