Re: how to edit a function from psql?

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Karim Nassar <Karim(dot)Nassar(at)NAU(dot)EDU>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Patrick Hatcher <PHatcher(at)macys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: how to edit a function from psql?
Date: 2004-11-08 03:36:20
Message-ID: 5B5E0190-3137-11D9-B0FA-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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+...
>
> \<.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-11-08 03:58:23 Re: RFD: comp.databases.postgresql.general
Previous Message Russell Smith 2004-11-08 02:53:47 Re: index not always used when selecting on a date field