Re: how to edit a function from psql? - Mailing list pgsql-general

From Thomas F.O'Connell
Subject Re: how to edit a function from psql?
Date
Msg-id E559C6DE-2EAC-11D9-9323-000D93AE0944@sitening.com
Whole thread Raw
In response to Re: how to edit a function from psql?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: how to edit a function from psql?
List pgsql-general
Alvaro,

How do you get the results of \df+ into the buffer with \e? Just copy
and paste?

-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 3:40 PM, Alvaro Herrera wrote:

> On Thu, Nov 04, 2004 at 02:22:06PM -0600, Thomas F.O'Connell wrote:
>> To the best of my knowledge, this is not possible in psql.
>>
>> You can edit individual queries with \e, but I don't think it's
>> possible to edit functions.
>
> It is of course possible get the definition using \df+ and then use
> CREATE OR REPLACE in conjuntion with \e to edit it at will.
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> Tulio: oh, para qué servirá este boton, Juan Carlos?
> Policarpo: No, aléjense, no toquen la consola!
> Juan Carlos: Lo apretaré una y otra vez.

pgsql-general by date:

Previous
From: Patrick Hatcher
Date:
Subject: Re: how to edit a function from psql?
Next
From: Alvaro Herrera
Date:
Subject: Re: how to edit a function from psql?